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!

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!