Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

combining spreadsheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Combining spreadsheets

Combining spreadsheets

ResolvedVersion 2003

James has attended:
Excel Advanced course

Combining spreadsheets

I want to combine two spreadsheets that have one common field (invoice numbers) so it can combine the two sets of data by common account numbers

RE: Combining spreadsheets

Hello James

Thank you for your question and welcome to the forum.

Are the invoice numbers only listed once in each spreadsheet? If so I think you could use VLOOKUP, assuming that the details about the invoices are recorded in columns.

Please let me know if this helps or not.

Kind regards
Amanda

Excel tip:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.