Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conbine lists from multiple worksheets
i am hoping some excel wizard can help me here and not tell me i should use
Access. anyway, i have several lists of names on about 15 tabs/worksheets. each list is a different length, one column wide, and i want to combine them to come up with 1 master. i don't want to eliminate duplicates and i want it to auto-update if an additional name is entered on one of the tabs. i've tried the "offset" function with the insert name range which works, but i can only have up to 7 functions in my formula, and since i have more than 7 tabs, i don't know how i can use it. so alas, here i am seeking some guidance because i feel i'm close, but oh sooooo far away. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
lists w/ multiple worksheets q | Excel Discussion (Misc queries) | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
Update multiple worksheets | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |