When one references another worksheet i.e.
Sheet1 A1 = Sheet2!A1
when one copies the reference to Sheet1 A2 sas automatically
increments by 1 giving
Sheet1 A2 = Sheet2!A2

How does one make excel skip a row:

I want 2 lines copied consecutively then 1 line skipped automatically.

Using the above notation I am trying to get
Sheet1 A1 = Sheet2!A1
Sheet1 A2 = Sheet2!A2
Sheet1 A3 no mapping
Sheet1 A4 = Sheet2!A3
Sheet1 A5 = Sheet2!A4
Sheet1 A6 no mapping and so on for a few
thousand rows.

Thanks In Advance,
John


--
caraj
------------------------------------------------------------------------
caraj's Profile: http://www.excelforum.com/member.php...o&userid=33718
View this thread: http://www.excelforum.com/showthread...hreadid=535003