I have 2 worksheets that need to be merged together into one. One
worksheet will be used as my main sheet, the other has the additional
information to be merged into the main sheet. I have a column in each
spreadsheet that has the item numbers listed...those numbers are the
same in each spreadsheet and will be used as my "reference" between
the two spreadsheets, however there is data on one sheet that is not
on the other that will also need to be merged into the main. I've
been trying to use Vlookup to get the data from the second worksheet
to merge with the main worksheet but the only information I'm not
getting all the data. Any help on if Vlookup is capable of pulling
all the data for me or is there a simplier way of merging the 2
worksheets without having to create a macro...each worksheet has
approximately 3000 rows of data. I hope my request makes sense...Any
help would be greatly appreciated.