Consolidating text information
 

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 information
 

what does the data look like? user ID's in Column 1 and functions in Column
2, or mixed together?

"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!