Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update a list and don't show blanks
I have a workbook with multiple sheets, various users will add information on
certain sheets. These sheets then need to link to a master sheet which will have all the information. To do this I can use hlookups etc. or straight linking. However I don't know how much information is going to be inputted so I need to allow for 100 rows of information on each sheet. This means I have lots of blank columns. If I use an auto filter then that has to be refreshed each time to add the new information. Is there another way of doing this so it works automatically? Finally I can't use macros as this needs to run on both Excel 2003 and 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ATTN : Ron (Multiple Dependent DV List Auto Update) | Excel Worksheet Functions | |||
ATTN : Ron (Multiple Dependent DV List Auto Update) | Excel Worksheet Functions | |||
Auto Update validation list? | Excel Worksheet Functions | |||
Auto Update validated list wording? | Excel Worksheet Functions | |||
Auto Update A Validation List | Excel Worksheet Functions |