Hi, I need of a Macro to copy and past some cells on excel, i mean:
I have 2 sheets: in the first one i have some data/numbers that I updat every week, so I have for every week different numbers. I have to copy these numbers on the second sheet, but i don't want to paste the numbers on the cells of the previous week. I tried to record a macro using excel and i got:
The problem is that using this macro I override the cells everyweek: i need that every week the new numbers have to be paste on the next column in the second sheet.
Example
Sheet 1
Column 1 (09/19/11)
1.2
2.9
3.4
4.5
5.6
Sheet 2
Column 1 (09/05/11) Column 2 (09/12/11) Column 3 (09/19/11)
2.5 ||| 2.4
2.6 ||| 3.5
7.4 ||| 2.8
8.9 ||| 5.2
5.6 ||| 9
As you can see I want to copy and past the value for the updated numbers. If I use the macro i've created i will every week write on the same interval.
The macro should recognizes the blank cells (without any number) which follows written cells with number (in the example i want to paste the value on the column 3, and the following week on the column 4. etc...).
Then I want also to copy from the second sheet the last 4 columns written with numbers on the first sheet: it's a dynamic copy and past because i want that the range of the copy and past would follow the updated cells.
Thanks in advance.
Damiele
Bookmarks