| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula between worksheets
To gather the data of the cell $P$31 from the worksheets in a single total
sheet I would do the following: - Write the numbers from 1 to 301 in column A - Write this formula in column B: = A1 & "!$P$31" - Rewrite the if formula to use indirect: =IF(D1=0,0,INDIRECT(B1)) You know better what layout works for you, but I hope this helps. Miguel. "copying formula of multiple worksheets" wrote: Heres my formula =IF(B2=0,0,'1'!$P$31) 1 is worksheet 1, I have 310 worksheets and a total sheet, How can I copy this formula down to show worksheet 2 then 3? thanks alot |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help on information sharing between 3 worksheets | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| How do I copy a reference formula onto multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
