#1
|
|||
|
|||
Help multiple sheets in one sheet
I need help, how to in one sheet place values from different sheets (30 row for each sheet). Also is it possible to have that in sheet that collect values, hide empty cell but when cells in multiple sheet are filed, hidden cell are visible again Thanks in andvaced Aleksandar |
#2
|
|||
|
|||
Quote:
Quote:
To my knowledge you can hide a row (16,384 cells) or a column (1,048,576 cells) but not single cells. |
#3
|
|||
|
|||
Quote:
1. when the workbook is opened; 2. with frequency you can determine (but this option freezes the workbook for time the query is refreshed, and this may be annoying - I myself never use this option); 3. you can refresh the query manually whenever you want. Ever better advice - keep your data entry on single sheet and add a column with allows to differ data type in row (equivalent of sheet name in your current setup). Then you can: a) use autofilter to display one (or couple) of data type(s) only; b) Create a report sheet, where you can select the data type (use Data Validation List for this cell), and use formulas to populate a report table with selected type of data. You have 2 sheets instead of whole bunch of them, and you have same functionality. |
#4
|
|||
|
|||
Thank you very much
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
Complex calculation from multiple sheets to master sheet | inreality01 | Excel | 49 | 01-06-2016 03:09 PM |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel Programming | 8 | 06-12-2014 10:04 PM |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel | 1 | 06-11-2014 04:01 AM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |