February 21, 2019
I really need help with this. So here is my problem.
I have 50 Case Mangers in different parts of the state
--- they have 50 Participants
Each participant has a separate file.
That means approximately 250 separate files are sent to me monthly.
Each file has approximately 10 tabs
Tab 1 Tab 2 Tab 3 etc.
I have named one of the tabs MIS it has 176 Data Elements that need to be answered.
That means I am collecting approximately 900 Data Elements.
By Data Elements I mean 900 cells of information collected in separate cells.
The Data Elements are in (Column A Row 1) and end in (Column FV Row 1).
I need to collect all this Data in to one spreadsheet and submit it once a month.
Each Participant file has a tab labeled MIS
So, I need to grab that tab from all Participant files and combine them into one spreadsheet.
Is there a way to do this? I have searched and found
Get and transform data
Thanks Gerri Johnson
June 25, 2016
You can give this Add-In a try. I think it will be useful for your situation.