| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy records that are 4 rows apart
Dear reader,
I have a bit of a problem copying from one worksheet to another. I need to copy some dates from worksheet B to worksheet A. Currently these worksheets are set up this way WORKSHEET A - A B 1 Part Date 2 xy 3/24/08 Formula used: =(worksheetb!B5) 3 yz (I would like a formula that will skip four rows and copy cell B9 WORKSHEET B (contains the data I need to copy) A B 1 Part Date 2 3 (Cells A2:A5 are merged) 4 5 xy 3/24/08 6 7 (Cells A6:A9 are merged) 8 9 yz 3/25/09 Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number of rows/records for the specified period | Excel Worksheet Functions | |||
| Copy specific records from a worksheet to another | Excel Worksheet Functions | |||
| How do I copy records with specific text from one wkbk to another | Excel Worksheet Functions | |||
| Checking for duplicate records / rows | Excel Discussion (Misc queries) | |||
| Removing all duplicate records except one copy | Excel Discussion (Misc queries) | |||
Threaded Mode
