Herbiec09
05-11-2013, 08:22 AM
Hi all,
Looking for some help on a quirky copy paste scenario. I would like to set up a consolidation spreadsheet for a number of companies in a group by creating a mini database that i can have formulas looking into.
I have a template that each of our 5 companies uses to submit their information. The info i am copying is in say column B. This information needs to be copied into another excel spreadsheet. Is vba clever enough to paste the data into certain columns depending on the month that the data relates to say. An example would be January data would be copied from column b in the source spreadsheet to column c in the database. The following month when I run the macro, February data (exactly the same template as Jan) wud be copied from column b in the source spreadsheet to column d in the database etc.
Could anyone assist with a code and ways to set this up.
Thanks
Herbez
Looking for some help on a quirky copy paste scenario. I would like to set up a consolidation spreadsheet for a number of companies in a group by creating a mini database that i can have formulas looking into.
I have a template that each of our 5 companies uses to submit their information. The info i am copying is in say column B. This information needs to be copied into another excel spreadsheet. Is vba clever enough to paste the data into certain columns depending on the month that the data relates to say. An example would be January data would be copied from column b in the source spreadsheet to column c in the database. The following month when I run the macro, February data (exactly the same template as Jan) wud be copied from column b in the source spreadsheet to column d in the database etc.
Could anyone assist with a code and ways to set this up.
Thanks
Herbez