Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating Text Info
Hi,
I have 4 tabs with approximately 60,000 lines of data on each tab. The information that is on these tabs are user id's and functions that they can access. I would like to combine these tabs so that the user id shows only once but lists all accessable menus. Is there a macro that I could use? Or any other ideas? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating Text Info
It's really pretty hard to advise about this without knowing more about your
dataset(s)........but, assuming all four tabs are laid out the same, you may be able to do something with the Autofilter, or maybe a macro to run four autofilters and copy results over to a new tab, to collect all the data about one UserID, then maybe condense it from there.........no easy one-liner solution here, this is a project. Vaya con Dios, Chuck, CABGx3 "wilma2299" wrote: Hi, I have 4 tabs with approximately 60,000 lines of data on each tab. The information that is on these tabs are user id's and functions that they can access. I would like to combine these tabs so that the user id shows only once but lists all accessable menus. Is there a macro that I could use? Or any other ideas? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating text information | Excel Discussion (Misc queries) | |||
Extracting Info From Within A Text String | Excel Worksheet Functions | |||
sum of 1 column if info in another = specific text | Excel Discussion (Misc queries) | |||
How do I extract text info from 1 excel worksheet into many? | Excel Discussion (Misc queries) | |||
info in cel needs to propt other cels to automatically enter text | Excel Worksheet Functions |