Report Lookup Data

amcmlt

Board Regular
Joined
Feb 2, 2015
Messages
82
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!
 

Forum statistics

Threads
1,086,012
Messages
5,387,222
Members
402,053
Latest member
gui24

Some videos you may like

This Week's Hot Topics

Top