Set row equal to another row

[Redbeard]

Hey,
I know how to set a cell equal to another cell and have it maintain that reference even if moved to another sheet. Is there a way to do that with an entire row? Have each cell in the duplicate row match the corresponding cell in the source row? Or do I just need to set it up one cell at a time?

Thanks

[timpani]

Hi Redbeard,

Say row 1 has the data you want to duplicate.

You can set cell A2 to be "=A$1". Then select the cell, copy, click on the left hand side of row 2 so that the whole row is selected, and paste.

Is that what you were after?

[Redbeard]

Outstanding! Thanks very much for your help. The cells that are blank in the source row show up as zero in the duplicate row. Any way around that? Thanks again for your quick help.

[timpani]

Well, instead of pasting into the whole row, you could just select the cells you're interested in and paste into those.

But if that's too fiddly (maybe you want to add more data to the source row later on, for example), setting A2 to be "=IF(A$1<>"", A$1, "")" and then copying and pasting that into the whole row will also work.

Cheers,

Tim

[Redbeard]

Thanks again for the help, Tim.