Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have two spreadsheets. They are somewhat identical. The big file has
thousands of products showing how many are in stock. The smaller file has a fraction of these same products and I need to update the quanity in stock field in my smaller spreadhseet every day. Is there a script or method I can use to have this done without doing each cell one by one? Thanks, Rick |
#2
![]() |
|||
|
|||
![]()
The easiest method is to use VLOOKUP(). See:
http://www.cpearson.com/excel/lookups.htm -- Gary''s Student "Rick" wrote: I have two spreadsheets. They are somewhat identical. The big file has thousands of products showing how many are in stock. The smaller file has a fraction of these same products and I need to update the quanity in stock field in my smaller spreadhseet every day. Is there a script or method I can use to have this done without doing each cell one by one? Thanks, Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linkage data between two spreadsheet | Excel Worksheet Functions | |||
Updating External Data | Excel Discussion (Misc queries) | |||
UserForm Data to Spreadsheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Updating 1 spreadsheet from another | Excel Worksheet Functions |