Hi
I want to copy a column of numbers from Column A Sheet1 to Column A in sheet 2 in the same workbook.
The action is done once per week and each week in Sheet 2 the column changes and moves one column to the right (On the second week the numbers are copied into Column B and so on).
How do I create a formula to do this?
Thank You for your help
Terry
You may use the formula =Sheet1.An (being n the row number) in all needed cells/columns in Sheet2. Then, each week, you can use menu Data - Text to Column on a new column.
[[2 years after]]
can’t really deal with this event once per week in a formula.
you’d rather need a macro or a filter.
and maybe simpler, instead of using only column Sheet1.A, just hide B:AZ, then each week you have to do 1 hide/unhide 