ExcelBanter - IF formula between tabs

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF formula between tabs (https://www.excelbanter.com/excel-discussion-misc-queries/224196-if-formula-between-tabs.html)

scootr

IF formula between tabs

If cell D2 in tab 1 has the letter "A" in it then I want the entire row of
cells (A2 - O2) to be copied into tab 2.

Is there a formula that can accomplish this?

David Biddulph[_2_]

IF formula between tabs

In Sheet2!A2 use the formula
=IF(Sheet1!$D2="A",Sheet1!A2,"")
or perhaps (to cope with blanks)
=IF(AND(Sheet1!$D2="A",Sheet1!A2<""),Sheet1!A2,"" )
and copy across.
--
David Biddulph

"scootr" wrote in message
...
If cell D2 in tab 1 has the letter "A" in it then I want the entire row of
cells (A2 - O2) to be copied into tab 2.

Is there a formula that can accomplish this?

scootr

IF formula between tabs

I tried both forumlas. I copied them across and down. But how do I get rid of
the blank cells?

"David Biddulph" wrote:

In Sheet2!A2 use the formula
=IF(Sheet1!$D2="A",Sheet1!A2,"")
or perhaps (to cope with blanks)
=IF(AND(Sheet1!$D2="A",Sheet1!A2<""),Sheet1!A2,"" )
and copy across.
--
David Biddulph

"scootr" wrote in message
...
If cell D2 in tab 1 has the letter "A" in it then I want the entire row of
cells (A2 - O2) to be copied into tab 2.

Is there a formula that can accomplish this?

All times are GMT +1. The time now is 05:45 AM.