![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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? |
#3
|
|||
|
|||
![]()
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.
|
#4
|
|||
|
|||
![]()
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 |
#5
|
|||
|
|||
![]()
Thanks again for the help, Tim.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Chayes | Excel | 1 | 07-20-2012 03:07 AM |
Make row in one sheet equal column of another | hypertyper | Excel | 6 | 01-31-2012 03:48 PM |
Automatically change the value of one cell so that two other cells become equal | matthew544 | Excel | 5 | 09-18-2011 08:56 AM |
Dividing merge cell into ten equal rectangles for inputing Digit? | aligahk06 | Excel | 0 | 05-12-2010 06:56 AM |
![]() |
brians | Excel | 5 | 03-09-2010 12:04 PM |