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

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

Hi rob.. thks! i've tried. it does go to the next cell down but when i change
the data in sheet 1, i need it to go again to the next cell down. it has to
continue to go to the next cell down as new data will be filled in each row.

nana.




"RobN" wrote:

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

nana

Rob meant for you to copy the formula down the column as far as you wish.

His formula will give you a column of zeros until data is entered in Sheet1

Try this to get rid of the zeros.

=IF(Sheet1!C3="","",Sheet1!C3) in A6 of Sheet2

Click on the black square at bottom right corner of A6 and drag down as far as
you wish.


Gord Dibben MS Excel MVP

On Sat, 20 Oct 2007 00:33:06 -0700, nana wrote:

Hi rob.. thks! i've tried. it does go to the next cell down but when i change
the data in sheet 1, i need it to go again to the next cell down. it has to
continue to go to the next cell down as new data will be filled in each row.

nana.




"RobN" wrote:

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