copy and paste of columns with interval

**pani_hcu** · 08-16-2009, 06:57 AM

Hi All,

I am trying to sort out a problem, Here we go...
A B C................ AE
Comapany 2000 2000 2001
a NetIncome PBIDTA Net Income
b ..........

c .......

Then my data set contains data on differenct variable for different companies. The data starts from Column B. 2000 is the year name. I have data for 2000-03. But the data for Net Income for different year is located in different columns. Which is also true for all the variables. I want to rearrange the columns for the same variables for different time period.

A B C................ D
Comapany 2000 2001 2002
a NetIncome Net Income Net Income
b ..........

c .......

I am not able to record a macro which will select the columns and then will paste in another sheet according to their year. Any suggestion will be appreciated. I have attached the workbook for the same. I have explained the desired format in the final data sheet.

With hope,
Upananda

**Special-K** · 08-16-2009, 07:09 AM

Like this on "Final data"? Its just a reference to the "Data" sheet for the specific columns

**pani_hcu** · 08-16-2009, 07:18 AM

Hi K,

Thanks a lot for ur reply. I think that u have given the right solution, that is what i am looking for. How i will do for other variables ? . I would be highly grateful if u guide me the formula to use for other variables.

Regards,
Upananda