Can Excel do this?

kylith

This might be a bit complicated, and possibly impossible, but here goes:

I am doing some work with Excel at the moment, and what I'm looking to do is to have rows automatically copy to Sheet 3 when certain criteria are met; i.e when F21=Yes then row 21 automatically copies to Sheet 3. It's for an order form so it's for when someone fills in an order in the catalogue on Sheet 1 it automatically fills in the order form on Sheet 3.

Hopefully this makes some sense; thanks in advance

MiniNukinfuts

Have a look at this link: reference other sheets

That's the first result I got from google, so there should be much better pages out there.

kylith

MiniNukinfuts wrote: »

Have a look at this link: reference other sheets

That's the first result I got from google, so there should be much better pages out there.

Thanks for that, it's tricky because I don't really know how to phrase it for a search.

I'm familiar with =Sheet1!A15 etc, what I'd be looking for is more =if(Sheet1!A15>0)then copy A1:A20 onto Sheet3.

MiniNukinfuts

I just wrote this there, is this what you need:

=IF(Sheet1!C1 = "YES", SUM(Sheet1!A1,Sheet1!B1),0)

KAGY

You could just try a simple filter.

Or look into pivot tables, they will create a summary, including any multiplication or summing you need to do.