copy and paste values rolling columns macro

Hi guys!

I have problem with a Macro.

Here what I want to do.

There are two sheets: Sheet 1 and Sheet2. Sheet2 will be updating everyday automatically. So, what I am interested in is creating a Macro which allows me to copy two cells (always the same N7:N8) from Sheet2 in Sheet 1 in a rolling logic. So, ideally, the first time it will run, the macro will copy those value in N7:N8 (sheet 2) and paste them in A7:A8 (sheet 1); the second time it will paste them in B7:B8, the third time in C7:C8 and so on. I need something which detect the "not empty cell" and paste the value in the cell belonging to the column right after the "not empty cell".

Help it would be super !
thanks!

Hey, try this one

Please Login or Register  to view this content.

Thanks guys!!! You two saved my day !

Thank you very much!

Actually I have another problem:

I was wondering how i can write a formula in VBA for calculating the variation in %(e.g. expressed (N7-M7)/M7 ) of the last two values just pasted.

Ideally this formula will calculate the following
The first time, the formula will calculate (N7-M7)/M7, being N7 the last column "not empty". The secon time the formula will calculate (O7-N7)/N7, being O7 the last column "not empty". And so on.

I know you already saved my day, I was wondering if you could save my weekend
thanks again,
Dan