Thread: [Solved] Set row equal to another row
View Single Post
 
Old 07-25-2012, 09:33 AM
timpani timpani is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2012
Posts: 12
timpani is on a distinguished road
Default

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
Reply With Quote