nana,

If I'm reading this right all you need are some simple formulas. With what
you have given, place this formula in A6 of sheet 2.
=Sheet1!C3
Then copy down as far as needed. Do similar for the other data.
If Sheet1 is not the name of the sheet you'll need to change that of course.

Rob


"nana" wrote in message
...

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