Update between spreadsheets

S

Shae

How do I update between spreadsheets?

We use our spreadsheets as databases for our website. I then create flat
text files to upload into the site. When a vendor notifies us of a price
change, I have to go in manually and update each spreadsheet. How do I have
them check automatically? The main problem is that the updates we are sent
are in a very different layout than what I use. I may have to change their
layout to match mine and then update. i.e.:

Their layout:
Part No. 10K Jobber (those last two are pricing categories)

Mine:
Part # Description Model # Notes Price

I do have a column of their part numbers already created in my lists for
reference. Any way to just have that check against mine and update a price
if necessary?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top