Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
This should be simple for someone
Just not able to figure it out myself...I simply need the formula to pull a
cell in every 6th row into a new worksheet. When I copy down, it doesn't recognize to advance 6 rows. I want to bring these over without manually editing each cell....of course, with the amount of time I have tried to figure this out, I could have done it manually! (but I am stubborn!) I have just been using the "equal" and selecting the cell from the first sheet, but that is extremely tedious. Here is what I have ='OPTIONS ASSEMBLIES'!E1733 to Cat08 cell D24 ='OPTIONS ASSEMBLIES'!E1739 to Cat08 cell D25 I need E1745 for D26 and E1151 for D27 and so on, and so on, and so on for pages and pages This should be simple, right? Thanks smart people! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |