Merging two different excel spreadsheets

N

nectarinesupreme

Hi all, I am very novice with Excel and I have a problem that I don't
even know where to start with. I have two different Excel spreadsheets
that have data for different television programs. I need to go through
and compile all of the data into one sheet. The main issue is that
there are different variations in both of the spreadsheets in how the
television programs are named. I am looking to find a way to go
through one column of television names and find the match in the other
spreadsheet. Is there any function or method that I can use to do
this? Thanks for the help!
 
D

Dave Peterson

You have suggestion at your other post.

Hi all, I am very novice with Excel and I have a problem that I don't
even know where to start with. I have two different Excel spreadsheets
that have data for different television programs. I need to go through
and compile all of the data into one sheet. The main issue is that
there are different variations in both of the spreadsheets in how the
television programs are named. I am looking to find a way to go
through one column of television names and find the match in the other
spreadsheet. Is there any function or method that I can use to do
this? Thanks for the help!
Click to expand...
 

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

Merging two Excel spreadsheets 4
Combine two spreadsheets into one 3
Section Breaks in Excel 5
Concatinating two spreadsheets by a column 4
Compare two spreadsheets 1
Compare two workbooks and hi-light matches 0
Bypassing password protection in Visual Basic 9
joining spreadsheets together for reports and queries? 1

Top