I would suggest worksheet_change event code but need a couple of
details.............

How do Sheet1 A1:E1 cells get changed or updated?

Would you want the code to run when any of Sheet1 A1:E1 were changed
or only when all of them were changed?


Gord

On Tue, 29 May 2012 16:13:28 +0000, erstaples
wrote:


Hi all--

I have a workbook with sending cells A1:E1 on Sheet1.

What I would like to do is link these to Sheet2 and have A1:E1 populate
down the rows in Sheet2 each time the values in A1:E1 are changed or
updated in Sheet1... For instance, the first time cells A1:E1 are filled
in Sheet1 it populates A1:E1 on Sheet2, the second time these sending
cells are filled it populates A2:E2 on Sheet2, to A3:E3, and so on.

I am quite new to Excel, but I have done an extensive bit of research on
the web for answers to this scenario, and I haven't had any success
finding a solution.

Could anyone point me in the right direction or tell me what I need to
do to make this work?

Thanks, and apologies ahead of time if this question has been asked on
these boards before. I didn't see it.

Eric