User Profile
cliftonmurphyjr
Copper Contributor
Joined Mar 01, 2020
User Widgets
Recent Discussions
migrating data from one sheet to another
Ive got two Excel files. One we will call file-A and one we will call file-B. I have a column in both sheets called "SKU" and a column called "PRICE". I need to know how to get Excel to search through file-B for any SKU matching a SKU from file-A and import the data for the "PRICE" of that skew from file-B into the "PRICE" for that SKU in file-A. The problem is that file-B has all the prices, and file-A doesnt have any. At the same time there are 4000 rows in file-B and only 1200 in file-A...basically i am needing to import the prices for those 1200 products in file-A from file-B. Can anyone give me a tutorial step by step on how to do this, or point me to a step by step on how to do this?1.4KViews0likes3Comments
Recent Blog Articles
No content to show