Macro for sorting & moving data into new tabs

Microsoft Excel 2003 (full product)
January 19, 2010 at 11:18:25
Specs: Windows XP
Hi,

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.

For example:


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.

Thanks!



See More: Macro for sorting & moving data into new tabs

Report •


#1
January 19, 2010 at 17:53:19
What have you got so far?

Report •

#2
January 19, 2010 at 21:32:24
Post this in the Office forum for more help. Link is on the right

Home Page http://ewen.uuuq.com/


Report •
Related Solutions


Ask Question