Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link all data from several workbooks to one "master" workbook
I'm trying to link data from several workbooks into one "master" workbook.
Basically there will be a bunch of workbooks with Questions (I.e. A. Did you do this? B. Did you do that?) and either "yes" or "no" to those questions. Then I want all those answers to be pulled into the "master" workbook and maybe using a 'count' feature.. I want the master workbook to display: Yes No Question A 7 3 Question B 4 6 Anyone have any ideas on how I can do this or something similar?? Much appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link all data from several workbooks to one "master" workbook
Maybe you like this add-in
http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "bchin2020" wrote in message ... I'm trying to link data from several workbooks into one "master" workbook. Basically there will be a bunch of workbooks with Questions (I.e. A. Did you do this? B. Did you do that?) and either "yes" or "no" to those questions. Then I want all those answers to be pulled into the "master" workbook and maybe using a 'count' feature.. I want the master workbook to display: Yes No Question A 7 3 Question B 4 6 Anyone have any ideas on how I can do this or something similar?? Much appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
Excel unable to importa data from "mdb" file link | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
"Adding" rows from one workbook to another, and expanding workbooks by row | Excel Discussion (Misc queries) |