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