Forum Discussion
Please help! Cell Reference To A Shared Workbook
I have a workbook with a list of locations. I parse out shared workbooks to respective regional managers. The regional managers enter contractor information and hours worked at each location. I want...
You could pull in the data from the workbooks using e.g. Data, New Query (or get data), From File, From Folder. Then once you have all information in one table, reporting gets easier.
Thanks, JKPieterse . How do I Get Data from a cell as opposed to a sheet?
- I was assuming you need more than just one cell from those sheets :-)
