i have been asked to make an excel sheet which collects data from other excel workbooks being updated daily on a shared drive. I have several workbooks, each updated daily by different poeple. i want selected information in each workbook to be...
i have been asked to make an excel sheet which collects data from other excel workbooks being updated daily on a shared drive.
I have several workbooks, each updated daily by different poeple. i want selected information in each workbook to be collated to the one workbook.
Each new day, the new information is updated in the original several workbooks. this new information is then to be saved again to the collated workbook, below the previous data.
what is the best way to go about this?
should a button be inserted into each of the workbooks being updated daily that when pressed, exports the data to my workbook or is there a more efficient way?
Linear Mode
