Should be quick and easy to do this in excel but drawing a blank

E

ewt

I have 2 spreadsheets lets say for example one is a master product list with
prices the other is what the individual store carries so it is a subset, but
it has no pricing I would like to automate to fill in the pricing. In
otherwords I would like it to look it up in the master product file then fill
it in in the store file. How would this best be accomplished?
 
L

Luke M

You could prb use a VLOOKUP function copied down to bring in the prices. If
you need it to be static, simply do a copy, paste special - values.

If you *really* needed this to be automatic/programmed for some reason,
simply record a macro of you doing said actions. (and modify to make dynamic)
 
E

ewt

This did not work, they are in 2 seperate spreadsheets, and the master table
has more value than the individual store tables
 

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

Similar Threads

Filtering several rows on different criteria to build a single row. 1
How do I apply 'custom' prices to goods and services? 3
copy a template and fill in data from a single worksheet 1
This has to be easy for someone but not me 3
How do i retreive data from another worksheet to a current one? 4
Trying to combine 2 Worksheets 1
Autofill down over blank cells until new data, and repeat. 1
What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1

Top