Copying Info

[jazmin2014]

Hello,

I need desperate help on how to do the following. I have an item list on Sheet 2 that has some radio buttons and check marks on different categories. The check marks cause a cell on a different column to list true (or false when not selected) and therefore figure out my pricing and quantity calculation. What I'm having trouble figuring out is how to get the lines that are listed as TRUE to copy the row it is on along to Sheet 3. I need to do this so that I can have a sort of summary order form without all the line items that are not being ordered.

Can anyone help me with this? I would be SO THANKFUL!! I've tried applying examples from other posts but can get it to work and I'm basically brain dead now because excel does that to my brain after long periods of confusion...

[Richard Buttrey]

Hi, and welcome to the forum.

Have you checked out the Advanced Data Filter functionality?

[jazmin2014]

No I have not. Thank you for directing me to that function. I'm going to check it out and give it a try!