Looking for help in how to create a report with data that is located in multiple worksheets.
I want to see how many entities I need from different sources to accomplish a high-level task (this should be an accumulation of all entities):
A = ####
B = ####
C = ####
D = ####
I want to see any prerequisite activities that need to be taken care of to accomplish tasks:
ACTIVITY 1: A = ####, B = ####, C = ####, D = ####
ACTIVITY 3: A = ####, B = ####, C = ####, D = ####
ACTIVITY 2: A = ####, B = ####, C = ####, D = ####
Etc….
The prerequisite tasks should be displayed in the correct order to accomplish task; example - Activity 3 must be finished before Activity 2
I have all the raw data (ie. The ###’s for A, B, C and D) in 26 worksheets. Each sheet has 40 rows representing A, B, C, and D ###’s for task requirement. Each row also has the ACTIVITY prerequisite listed (the ACTIVITY will come from 1 of the 26 worksheets) but the information should probably be coded different (any suggestions / advice would be appreciated on this would be helpful as well)
I have some VBA experience but this is way out of my league!
Thank you
I want to see how many entities I need from different sources to accomplish a high-level task (this should be an accumulation of all entities):
A = ####
B = ####
C = ####
D = ####
I want to see any prerequisite activities that need to be taken care of to accomplish tasks:
ACTIVITY 1: A = ####, B = ####, C = ####, D = ####
ACTIVITY 3: A = ####, B = ####, C = ####, D = ####
ACTIVITY 2: A = ####, B = ####, C = ####, D = ####
Etc….
The prerequisite tasks should be displayed in the correct order to accomplish task; example - Activity 3 must be finished before Activity 2
I have all the raw data (ie. The ###’s for A, B, C and D) in 26 worksheets. Each sheet has 40 rows representing A, B, C, and D ###’s for task requirement. Each row also has the ACTIVITY prerequisite listed (the ACTIVITY will come from 1 of the 26 worksheets) but the information should probably be coded different (any suggestions / advice would be appreciated on this would be helpful as well)
I have some VBA experience but this is way out of my league!
Thank you