Update prices in master XLS based on another XLS file

DJRikki

New Member
Joined
Mar 23, 2011
Messages
2
Hi there,

Im an Excel noob so please excuse my lack of knowledge here.

I am wanting to update a master price file on the PC with a seperate supplier price file that has been sent to me.

Unfortunately I cant just copy and paste one to the other as the arrangement of the master file means the rows dont match up on each.

What I think would work would be to have a formula or something similar that says "update the price field in master file with this value when column A = partnumber"

Im not the best at explaining things but what I mean is that in both files the common ground is the part number cell.

Many thanks for any assistance :)

Rikki
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top