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!