Herbiec09
07-04-2013, 12:10 PM
Hi All,
Could someone possibly assist with a quirky problem I am trying to solve.
I have data on Sheet 1 in a column, say A3:A15. I would like to copy this data to sheet 2. Now depending on the month that this data relates to, it should be pasted to a specific column. For example if it is month 1 data, it should be pasted into B3, month 2 data would go into C3, month 3 data would go into D3, month 4 data would go into E3 etc etc. How excel will know which month it is dealing with, will either be a cell on sheet one with the month number or an input box which allows the user to specify which month we are dealing with.
Can someone assist me with a code that could achieve this.
Thank you
Herbert
Could someone possibly assist with a quirky problem I am trying to solve.
I have data on Sheet 1 in a column, say A3:A15. I would like to copy this data to sheet 2. Now depending on the month that this data relates to, it should be pasted to a specific column. For example if it is month 1 data, it should be pasted into B3, month 2 data would go into C3, month 3 data would go into D3, month 4 data would go into E3 etc etc. How excel will know which month it is dealing with, will either be a cell on sheet one with the month number or an input box which allows the user to specify which month we are dealing with.
Can someone assist me with a code that could achieve this.
Thank you
Herbert