| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Should be quick and easy to do this in excel but drawing a blank
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Should be quick and easy to do this in excel but drawing a blank
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) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ewt" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Should be quick and easy to do this in excel but drawing a bla
This did not work, they are in 2 seperate spreadsheets, and the master table
has more value than the individual store tables "Luke M" wrote: 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) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ewt" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy way to add my custom button on Excel 2010 quick access toolbar? | Excel Discussion (Misc queries) | |||
| Is there a quick/easy way to get excel to replace ALL forumulas the numerical result in one step? | Excel Discussion (Misc queries) | |||
| Here's a quick and easy one.. | Excel Programming | |||
| Purchase entry (Invoices) in Excel, quick and easy. Does anybody k | Excel Programming | |||
| Quick and Easy! | Excel Programming | |||
Linear Mode
