Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Feeding data from one spreadsheet to another.
Hello,
I hope you guys can help me, I've had this issue that I'm dying to solve!. I have a spreadsheet that has around 15 colums, each line has unique information about a pc/laptop.. For example Col A: Asset Id number Col B: Description Col C: SMS Last update Col D: Primary User Now, in another spreadsheet, which is a direct dump from our CMDB I have a similar setup where you have Col A: Asset Id number Col B: SMS Last update Col C: Primary User I would like this second spreadsheet to update the associated SMS update and primary user update.. So it would search the second workbook and go, ok so Col A in the first sheet is W1125021 and Col A in the second workbook is W1125021, what is column B's data in the second sheet, ok, I'll put that in column C's data in the first wookbook. Hope you can help, and I hope this was understandable.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I pull data from a spreadsheet to another spreadsheet | Excel Discussion (Misc queries) | |||
How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
Automatic Feeding | Excel Discussion (Misc queries) | |||
Charts not updating when data feeding chart is changed | Charts and Charting in Excel | |||
Macro - Feeding path and file name to PDF maker | Excel Discussion (Misc queries) |