I have a spreadsheet of data and I was trying to create a macro that will seperate the data my office country and copy the rest of the according data to a new tab, then naming the tab the offices name.
Set of Books ID/Set of Books Name/Entity Code/ PA Code/ Resp Ctr Code/ Account Code/ Currency Code/ Actual Net Opening Balance
52121213/ France/ 0000/ 0000/ 0000/ 000000/ XXXX/ 24770712
5000564/ Germany/ 0000/ 0000/ 0000/ 000000/ XXXX/ 215413231
Any assistance would be greatly appreciated.