How to move cells when criteria met?

[Dyefrog]

I've done a search and have seen some similar dilemmas but can't seem to make them work for my situation.
I have 2 worksheets in same file and want to combine certain rows that meet certain criteria, e.g. when check box is on (true), pull that line of data to a third worksheet that will contain other data that also has check box on. Vlookup seems to be the appropriate function but i'm not doing something correctly or it's not the right function.
The other complication is the sheet that contains all these rows of data (sheet 3) should be in some logical organizational layout as it will be used as a public document showing the customers choices from the other two worksheets. It's hard to describe but see attached and it may prompt more questions. TIA

[stanleydgromjr]

Dyefrog,

How about having one sheet with all the Options - see the attached workbook.

You could combine all the "Options" sheets, onto the "Contract" sheet.

Then you could have several commandbuttons:
to display ALL Options to start with

to display only Elkridge Options
to display only Standard Options
to display only Custom Options

to display only checked Options
to hide all not checked Options


You would have to adjust some of your formulae.


Have a great day,
Stan

[Dyefrog]

I'm not familiar enough with Excel to know how to display only the checked items but my bigger concern is the printout would have large gaps where the unchecked items were. Can it then sort them in a concise layout?

[stanleydgromjr]

Dyefrog,

I'm not familiar enough with Excel to know how to display only the checked items but my bigger concern is the printout would have large gaps where the unchecked items were.

If you went with my idea, no, there should be no gaps in the printout.

Can it then sort them in a concise layout?

No.


I would suggest that you create the "Custom Options" and "Contract" sheets they way you would like them. Then we can automate the data flowing into the "Contract" sheet.

When you have done this, you can contact me via "Private Message", and we can take this offline.


Have a great day,
Stan