Merging information [Closed]

Report
Posts
1
Registration date
Thursday May 15, 2014
Status
Member
Last seen
May 15, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
I am taking inventory by sku number and have downloaded info from scanners and now I have it in excel and my original database is excel and I want to match up the 2 by sku and then merge them so the information will be merged and I will be able to see if there is a variance in my inventory.

If I am not asking this correctly please let me know as I am fairly new to excel and I just took over an account that hinges on me figuring this out so any help will be GREATLY appreciated.

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Mixxer40,

What I understand is that you have 2 files which you want to compare the "sku" number with.

It is unclear to me what you want when a match is found. You say you want to merge the information. Merge in Excel means to make multiple cells look like one.

Please explain in greater detail how your data looks now and how you foresee it.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!