Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you merge two spreadsheets to update data.
I have two spreadsheets with all columns and headings the same. One heading
is vendor numbers. The master spreadsheet I get contains many more vendors that I don't want to track. I want to update certain vendors by vendor number from one master spreadsheet every month and update the same info with a selected list of vendors every month. How do i do it. |
#2
|
|||
|
|||
Hi,
I would assume that some form of lookup will suffice, such as an INDEX or VLOOKUP. Use your help menu for a detailed description and examples on how they work. Once you get your head around them they're quite easy. Cheers, Jon "Gerrysr" wrote: I have two spreadsheets with all columns and headings the same. One heading is vendor numbers. The master spreadsheet I get contains many more vendors that I don't want to track. I want to update certain vendors by vendor number from one master spreadsheet every month and update the same info with a selected list of vendors every month. How do i do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts don't update when data changes | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
merge data problems | Excel Worksheet Functions |