G
Guest
I have a master worksheet with 4,000+ rows containing part numbers and
current prices.
I receive a weekly worksheet with 250+ rows of part numbers and new prices.
How can I automate the update of the master sheet with the new prices from
the weekly sheet?
I tried the VLOOKUP function in the master worksheet. If it can’t find a
matching part number with new price in the weekly sheet, then it fills in the
current price cell with the wrong price or “N/A†instead of just skipping
that row.
Thanks in advance,
Sailor JP
current prices.
I receive a weekly worksheet with 250+ rows of part numbers and new prices.
How can I automate the update of the master sheet with the new prices from
the weekly sheet?
I tried the VLOOKUP function in the master worksheet. If it can’t find a
matching part number with new price in the weekly sheet, then it fills in the
current price cell with the wrong price or “N/A†instead of just skipping
that row.
Thanks in advance,
Sailor JP