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