How do I consolidate files comprised of only text?

G

Guest

I have a large number of seperate files that have much but not all of the
same information in them. Is there any way for me to consolidate them all?
If I can consolidate them is there a way for it to rid the repeats and only
list what isn't repeated? These are files that contains names, contact
numbers, addresses, etc. They are all text without any functions. There are
labels at the top.
 
K

Kenny Dee

I'm trying to do the same thing as you mention, but you do have to make
sheets with formulas. I have about five sheets that ask about the same
information as my main sheet. I just enter the formula in the cells that
pulls the information from my main sheet that I enter once and only once. If
this is what you are talking about, reply back in I'll tell you what the
formula you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to consolidate data from different files? 2
How do I modify a query and consolidate data? 1
How can I count how many times different texts repeat in a column? 13
Importing Text Files Into Access 1
How do I consolidate archive folders in Outlook? 1
consolidating workbooks 2
how can i consolidate multiple contact folders 1
Excel EXCEL, how do I consolidate multiple rows to one row 1

Top