| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
tricky excel formula question
i use concatenate here
set up a sort list (using data/sort/custom list) then start the list of the sheet names then =concatenate("='",b2,"!$B$2") then copy, paste special - values type 1 in c1 copy, then.... select full range, paste special again and select 'multiply' this should force the cells to calculate hope this helps |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tricky Macro Question | Excel Worksheet Functions | |||
| Tricky Excel Formula Required! | Excel Discussion (Misc queries) | |||
| tricky excel formula | Excel Worksheet Functions | |||
| New guy with a tricky question | Excel Programming | |||
| Tricky Question | Excel Worksheet Functions | |||
Threaded Mode
