If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Consolidating Data
I am creating a checklist type data base for construction refurbishing.
We have a list of all items we will do for different rooms, exteriors and so on. If I have a 5 page master list and I only want to show the items we will be performing the work on. Is there a way to hide rows automatically if a certain cell is blank and then consolidate the data to a single page or as fits? |
#2
|
|||
|
|||
Consolidating Data
How are you determining what items to pick from your master list? Is it a
set of items depending on the job or is it just pick items as needed? I might be inclined to enter your master list on one sheet and then use formulas such a VLOOKUP to pick out only the ones that you require from the master list. Does your master list have a number next to each item or a code perhaps? "Steve" wrote: I am creating a checklist type data base for construction refurbishing. We have a list of all items we will do for different rooms, exteriors and so on. If I have a 5 page master list and I only want to show the items we will be performing the work on. Is there a way to hide rows automatically if a certain cell is blank and then consolidate the data to a single page or as fits? |
Thread Tools | |
Display Modes | |
|
|