Hi All,
Greetings!!! Main objective of this given task is as follows:---
To prepare a tracker that tracks a number of Lab samples received on a weekly basis - all on one google sheet spreadsheet with a tab for each client
There are 6 different clients. Each client's data is stored in separate folders in a specified drive. Each client folder contains Lab Transaction details that too again in different files.
For eg. a sample file is given below - Accu Ref Lab is the Master Tracker.
CRM - Lab is the report wherein I need to get the data for across the past 6 months stored in different files (Month-wise) and again in different folders for different clients.
Used Sumif formula in the same workbook but in a different worksheet. The solution is working as enclosed inm"Sheet 1" of Accu Ref Lab. However, the same doesn't work in a different Workbook or Spreadsheet
Greetings!!! Main objective of this given task is as follows:---
To prepare a tracker that tracks a number of Lab samples received on a weekly basis - all on one google sheet spreadsheet with a tab for each client
There are 6 different clients. Each client's data is stored in separate folders in a specified drive. Each client folder contains Lab Transaction details that too again in different files.
For eg. a sample file is given below - Accu Ref Lab is the Master Tracker.
CRM - Lab is the report wherein I need to get the data for across the past 6 months stored in different files (Month-wise) and again in different folders for different clients.
Used Sumif formula in the same workbook but in a different worksheet. The solution is working as enclosed inm"Sheet 1" of Accu Ref Lab. However, the same doesn't work in a different Workbook or Spreadsheet