| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing repeating non-consecutive rows
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula from consecutive rows to alternate rows? | Excel Discussion (Misc queries) | |||
| Transposing data from consecutive rows into non-consecutive rows | Excel Discussion (Misc queries) | |||
| Referencing A Non Consecutive Range? | Excel Discussion (Misc queries) | |||
| Inserting multiple rows in excel with data in consecutive rows | Excel Programming | |||
| Selecting consecutive rows in VBA | Excel Programming | |||
Threaded Mode
