| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
hide sheets use data
On Wed, 2 Nov 2005 13:28:01 -0800, j2thea
wrote: I've made a main sheet that pulls data from the other sheets. If I hide the other sheets with the data, my data isnt pulled from the other sheets. Is there a way, wihtout vb, to make the other sheets hidden but still usable? How does it 'pull the data' from the other sheets? That rather suggests that you're running a macro since I can see no reason why a formula which refers to cells on a hidden sheet wouldn't work. Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from different sheets in one | New Users to Excel | |||
| transfer data in excel between sheets | Excel Discussion (Misc queries) | |||
| Chart sheets cause data sheets to be blank | Charts and Charting in Excel | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
Threaded Mode
