Hello,
I am struggling with a solution to select data within cells and skip cells that are blank. The following is a description of what I have going:
Group 1 - Book Size
6 cells in 1 row
Cell shows the size based on selection made. The selection can require up to 3 sizes.
Group 2 - Book Weight
6 cells in 1 row
Cell shows the weight based on the selection made. Again if 3 sizes are needs, 3 weights will display
How do I create a report that will only include the cells that are not blank?
Report would be displayed as:
Group 1 first size listed and Group 2 first weight listed
This would repeat should 3 size/weight combinations are required.
Hope someone can show me the proper method to accomplish.
Thank you!
I am struggling with a solution to select data within cells and skip cells that are blank. The following is a description of what I have going:
Group 1 - Book Size
6 cells in 1 row
Cell shows the size based on selection made. The selection can require up to 3 sizes.
Group 2 - Book Weight
6 cells in 1 row
Cell shows the weight based on the selection made. Again if 3 sizes are needs, 3 weights will display
How do I create a report that will only include the cells that are not blank?
Report would be displayed as:
Group 1 first size listed and Group 2 first weight listed
This would repeat should 3 size/weight combinations are required.
Hope someone can show me the proper method to accomplish.
Thank you!
