Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Query data from same workbook
Hello all -
I have an excel workbook that queries external data that is stored on a different workbook but same computer. It works fine and I haven't had any issues with it. But, now I need to make this workbook easy to send to other users. I would like to consolidate the data and put it on the same workbook with my written queries. I figured it would be easy to do, similar to doing a pivot table on sheet1, and the data source on sheet2. This would make it much easier to send out to all the users so it can find the "data source" every time regardless of who's computer it's on. Can anyone point me in the right direction? Thanks. JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) |