good day...
i need help on this macro thingy!

i'm importing data from a .txt file that will be in sheet 1. This set of
data will always be changing.

from there, i need to copy dates and figures to sheet 2 with formulas.

1) for a date in sheet 1, say cell C3, how do i create a macro that will
paste to sheet 2 cell A6 and go to the next empty cell?

2) and from the next empty cell, repeat point 1 and go to the next empty
cell and so on...

Can we do this without using Visual Basic??

thks