HI All
I'm new to excel and am in desperate need of some help. I have two spreadsheets in the same workbook one has 241 rows the other has 6000+ rows. I need to extract and match the name and address information from Sheet 2 and add it to sheet 1. The idea being that at the end of the day I have one sheet containing all of the data. The issue I have is that in some cases the client identified on sheet 1 may have made multiple purchases, so I want to ensure I capture all of the transactions.
The are set up as:
Sheet 1 - Invoice, Quantity, Product Cost, Description, Date of Sale - This sheet has 6000+ rows
Sheet 2 - Invoice, Quantity, First Name, Last Name, Street, City, State, Zip - 241 Rows
Any HELP would be really appreciated.
Thank You
I'm new to excel and am in desperate need of some help. I have two spreadsheets in the same workbook one has 241 rows the other has 6000+ rows. I need to extract and match the name and address information from Sheet 2 and add it to sheet 1. The idea being that at the end of the day I have one sheet containing all of the data. The issue I have is that in some cases the client identified on sheet 1 may have made multiple purchases, so I want to ensure I capture all of the transactions.
The are set up as:
Sheet 1 - Invoice, Quantity, Product Cost, Description, Date of Sale - This sheet has 6000+ rows
Sheet 2 - Invoice, Quantity, First Name, Last Name, Street, City, State, Zip - 241 Rows
Any HELP would be really appreciated.
Thank You