Set row equal to another row

		Microsoft Office Forums > Microsoft Excel > Excel
Set row equal to another row

FAQ

Thread Tools

Display Modes

07-25-2012, 09:33 AM

timpani

Windows XP Set row equal to another row

Office 2003

Novice

Join Date: Jul 2012

Posts: 12

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Does 'Save as Unicode text' equal UTF-8	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
If A1 greater than or equal to 1 Then A3 = A2*A1	brians	Excel	5	03-09-2010 12:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 AM.