| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking incremental cells from another worksheet
I am trying to link every fith cell in a column to sequential lines on my
main worksheet. The formula I am using for the first cell link is =+'Master Query'!$F2 and I want the next cell to have the formula =+'Master Query'!$F7, the next =+'Master Query'!$F12, etc... for 500 lines. Anyone have ideas on how I can do this will minimal manual typing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace within Unlocked Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
| Excel worksheet linking | Excel Worksheet Functions | |||
| Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
| Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
