Conditional Cell Copying

[marlowem]

Hi,
I have a worksheet (named 'Budget Tracker') which lists line items to purchase. Column F has a simple Yes/No drop down which indicates if the cell data needs to be copied to a second worksheet (named 'PARTS').

Should column F state 'Yes', I'd like the cells to be copied to cells in the second worksheet. I've noted cells as copying the entire row would enter data that's not needed. I need to match-up the various columns/cells with the second sheet as the format is slightly different.

Is there an easy way to do this? A loop instruction etc?

Thanks

 

[Gary McMaster]

Maybe something you can use here:

http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/index.html

Gary