| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to move information from a column on one sheet to another s
Ok the problem starts out simple enough but I want to skip every other row.
I am having problems figuring out the formula to use to get it to go every other row. I have tried it with ='sheet2'!A2 and then on the next row having ='sheet2'!A4 and then trying to drag it down, but Excel doesn't recognize that pattern even if I continue it further. Is there a way I can make it pull the information every other row to where I can just click and drag the formula down like normal? Thank you for your help, Ben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MOVE SPECIFIC INFORMATION TO ANOTHER SHEET | Excel Discussion (Misc queries) | |||
| Move Column within Sheet with VB Macro | Excel Discussion (Misc queries) | |||
| How to move a column from one sheet to another by using functions | Excel Discussion (Misc queries) | |||
| Move exact information in a row as you sort a column | Excel Worksheet Functions | |||
| How do i keep a column stationary but move the rest of the sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
