Arrange data

[Nir Robinson]

Hi,

I have data (balance sheet) for 10 companies in different sheets.
Each sheet include all the company for specific month.
(All the sheets are exactly same)

I need to make sheets for each company for all the month.

What is the best way to do so?

Thanks a lot.

 

[Luke M]

Hi Nir,

I'd suggest starting by taking a look at some of the merge example on Ron's site here.
http://www.rondebruin.nl/win/section3.htm