Conditional copy
- Thread starter HVK1986
- Start date
you may be able to get the result that youre looking for with the IF function.
on sheet 2 in A1, you'd enter your first formula:
=IF(Sheet1!$E$1="S",=Sheet1!A1,"")
this is farily simple but has limitations.
-- You'd have to copy this formula to all the 'posisble cells'
-- when it come to a record where E1=R, then it will return a blank row in your list. (this could be later deleted manually if so desired)
im sure there are other ways, but this is only one.
let me know if you have trouble with this or if this isnt going to work and hopefully we'll get some better suggestions.
on sheet 2 in A1, you'd enter your first formula:
=IF(Sheet1!$E$1="S",=Sheet1!A1,"")
this is farily simple but has limitations.
-- You'd have to copy this formula to all the 'posisble cells'
-- when it come to a record where E1=R, then it will return a blank row in your list. (this could be later deleted manually if so desired)
im sure there are other ways, but this is only one.
let me know if you have trouble with this or if this isnt going to work and hopefully we'll get some better suggestions.
SirJB7
Excel Rōnin
Hi, HARRY!
Give a look at this file:
https://dl.dropbox.com/u/60558749/Conditional%20copy%20%28for%20HARRY%20at%20chandoo.org%29.xlsx
In first sheet it has a helper column F:
=E1&"_"&CONTAR.SI(E$1:E1;E1) -----> in english: =E1&"_"&COUNTIF(E$1:E1,E1)
In second sheet columns A:D hold the results:
=SI.ERROR(INDICE(Hoja1!$A$1:$D$25;COINCIDIR("S"&"_"&FILA();Hoja1!$F$1:$F$25;0);COLUMNA());"") -----> in english: =IFERROR(INDEX(Hoja1!$A$1:$D$25,MATCH("S"&"_"&ROW(),Hoja1!$F$1:$F$25,0),COLUMN()),"")
Regards!
Give a look at this file:
https://dl.dropbox.com/u/60558749/Conditional%20copy%20%28for%20HARRY%20at%20chandoo.org%29.xlsx
In first sheet it has a helper column F:
=E1&"_"&CONTAR.SI(E$1:E1;E1) -----> in english: =E1&"_"&COUNTIF(E$1:E1,E1)
In second sheet columns A:D hold the results:
=SI.ERROR(INDICE(Hoja1!$A$1:$D$25;COINCIDIR("S"&"_"&FILA();Hoja1!$F$1:$F$25;0);COLUMNA());"") -----> in english: =IFERROR(INDEX(Hoja1!$A$1:$D$25,MATCH("S"&"_"&ROW(),Hoja1!$F$1:$F$25,0),COLUMN()),"")
Regards!
Hi SirJB7
Your sheet is perfectly working. Thanks a lot
I just want to trouble u a bit more.
Now i have created 4 different sheets, sheet 2-audi, sheet 3 mahindra etc....
if in A1 the car is audi and in E1 if it is "S", i want the whole row to copy to audi sheet, likewise all car data to copy itself in its particulat sheets.
pls guide
Your sheet is perfectly working. Thanks a lot
I just want to trouble u a bit more.
Now i have created 4 different sheets, sheet 2-audi, sheet 3 mahindra etc....
if in A1 the car is audi and in E1 if it is "S", i want the whole row to copy to audi sheet, likewise all car data to copy itself in its particulat sheets.
pls guide
SirJB7
Excel Rōnin
Hi, HARRY!
Glad you solved it. Regarding your last requirement (which I hope & wish were the last, unless you want to go on changing the specs at each post...
joke... joke?) please download again the updated file from same previous link.
Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!
Glad you solved it. Regarding your last requirement (which I hope & wish were the last, unless you want to go on changing the specs at each post...
joke... joke?) please download again the updated file from same previous link.Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.
Regards!