Excel

  • Thread starter Thread starter Jack McCuen
  • Start date Start date
J

Jack McCuen

I have recently completed a 3 month course on excel, so
have gained sufficient knowledge to be dangerous, but I
have a ways to go.

Question: I have created an list of titles, order numbers
and pricing - all appearing in separate cells. A customer
can select titles by placing an "x" in a cell designated
for that purpose in each title row. What I want to do is
transfer all titles and key information selected with
an "x", to an order form - all at once. How do I do this?

Thank you.
 
Select your range (include the last header row).

Then Data|Filter|autofilter.

You'll see little dropdown arrows in the first row of your selected range. If
you chose more than one column, use the dropdown for the column with X's.

Choose X

All the non-X's will be hidden.

Now you can copy those visible cells and paste to a new worksheet?

Even better: Just leave them there hidden. Then when you make a change, you
just data|filter|Showall and add an X. Refilter on the X's and you're set.
(might be easier.)
 
Back
Top