kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hi,
I have this challenge here again.
I am pulling data from three sheets: "Group 1", " Group 2" and "Group 3".
I am not with my PC ATM so I used a sketch to proof my case.
My goal is to have the data from all three sheets displayed on another sheet as shown here
So, taking item X for example, we should have something like this:
This is how the data set is for each sheet, group 1 to 3:
So here, let us assume the database for group 1 to 3 start from column A where row 1 is a header.
And the sheet we are filling also start at same column A, row 1 being a header.
Since the sheet tabs have the group 1 to 3, while checking data on group 1, I want that group 1 appear as shown in the first or second image.
Then after that we check for group 2, leaving a blank row in between.
Then we repeat for group 3.
From the image 2, it shows what happens if only group 1 has data. And only two recorded events.
I hope this my explanation could get me a hit.
Thanks and please let me know if more details are required..
I have this challenge here again.
I am pulling data from three sheets: "Group 1", " Group 2" and "Group 3".
I am not with my PC ATM so I used a sketch to proof my case.
My goal is to have the data from all three sheets displayed on another sheet as shown here
So, taking item X for example, we should have something like this:
This is how the data set is for each sheet, group 1 to 3:
So here, let us assume the database for group 1 to 3 start from column A where row 1 is a header.
And the sheet we are filling also start at same column A, row 1 being a header.
Since the sheet tabs have the group 1 to 3, while checking data on group 1, I want that group 1 appear as shown in the first or second image.
Then after that we check for group 2, leaving a blank row in between.
Then we repeat for group 3.
From the image 2, it shows what happens if only group 1 has data. And only two recorded events.
I hope this my explanation could get me a hit.
Thanks and please let me know if more details are required..