Importing specific cells from a separate worksheet based on cell data

**pdmkh** · 11-20-2009, 12:07 PM

I currently copy and paste cell information contained in specific rows from one worksheet to another based on whether or not a specific cell in the row contains any data. For example; I will copy cells A10,B10,C10,D10,H10,Q10, and R10 only if Q10 has data entered. Any formulas to automate this process??

**firefly2k8** · 11-20-2009, 01:00 PM

If the source data is in Sheet2, the formulae in Sheet1 could read:

=if(not(Sheet2!Q10=""),M10,"")
=if(not(Sheet2!Q10=""),N10,"")

etc.

**Palmetto** · 11-20-2009, 02:05 PM

For example; I will copy cells A10,B10,C10,D10,H10,Q10, and R10 only if Q10 has data entered. Any formulas to automate this process??

There are a number of ways to "automate" the process, depending on how you define the term.

You could use a VBA macro (if that is an option for you), or you could simply link the cells on sheet2 to cells on sheet1.

Example: on sheet2, cell A10 might use this: =Sheet1!A10

You could also use Advanced Filter with criteria and use the option to copy matching records to a new location. This, too, can be automated to be run when criteria changes.

It is always helpful to post a sample workbook that accurately reflects your real WB and contains non-sensitive data of the same type your real WB uses.