create a list based on multiple criteria... complicated.

[Richard U]

Hello.

I have a spreadsheet that contains date, room, first and last name information.

I need to build a list based on exclusionary criteria, but only if the data is present.

Example, if only a date range is provided, then everyone that stayed between those dates would be listed.

If date, and room were provided, then only people in that room would be listed, et cetera.

my solution so far is to do a copy the data to a blank sheet, then remove what I don't need, but it's slow. I know I'm going at this the wrong way. any suggestions?

I can code this, it's the concept I'm having trouble grasping right now.

I'm recovering from a brain injury, so I'm re-learning quite a bit. Once I grasp a concept, I can code it, but not until then. sorry for such a basic question folks.

 

[sheetspread]

Will the data filter work for you? Or must it be a macro/formula?

 

[Richard U]

Will the data filter work for you? Or must it be a macro/formula?

It needs to be a macro, I'm using the data in processing later.

 

[sheetspread]

If you filter the data then select the visible cells with goto (F5) and copy them to another tab that should do what you want quickly. I'll try to find a macro to do this also but it may be difficult.........