import information from one sheet to onother

[adriana25]

Hi, can some one help me?

I have an worksheet (sheet1), in the cell A1 - 23.08.2011; B2 - "Thiery"; C2 - taupe
what kind of formula i have to do in onother sheet to import the info of sheet1, only if in teh cell C2 is "taupe"?

thanks

 

[Comfy]

Will this all be copied into one cell of let's say sheet 2 or to the relevant cells, A2, B2, C2 etc?

 

[adriana25]

in the sheet 2 will be also cells A2, B2, C2, with the same information, but with the condition that in the cell C2 of sheet1 have to be the word "taupe"

i tried with =iferror, but something is dosen't work

 

[Comfy]

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">bob</td><td style=";">said</td><td style=";">taupe</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">bob</td><td style=";">said</td><td style=";">nothing</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">bob</td><td style=";">said</td><td style=";">taupe</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";"></td><td style=";"></td><td style=";"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A2</th><td style="text-align:left">=IF(<font color="Blue">Sheet1!$C2="taupe",Sheet1!A2,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=IF(<font color="Blue">Sheet1!$C2="taupe",Sheet1!B2,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C2</th><td style="text-align:left">=IF(<font color="Blue">Sheet1!$C2="taupe",Sheet1!C2,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A3</th><td style="text-align:left">=IF(<font color="Blue">Sheet1!$C3="taupe",Sheet1!A3,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B3</th><td style="text-align:left">=IF(<font color="Blue">Sheet1!$C3="taupe",Sheet1!B3,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C3</th><td style="text-align:left">=IF(<font color="Blue">Sheet1!$C3="taupe",Sheet1!C3,""</font>)</td></tr></tbody></table></td></tr></table><br />

 

[adriana25]

thank you soo much, but i have excel 2003.. the formula is working, but i have to put the formula in each cell of sheet2... i now there is a way which gives me the possibility to copy all cells automatically

 

[Comfy]

Using your example.

Select A2, Then while holding SHIFT select C3.

Type the formula for cell A2 exactly, it's vital.

Then confirm the formula with CTRL + ENTER

 

[adriana25]

Dear comfy

thank you sooo much . I sincerly thanks from far Modova

 

[adriana25]

hi every one

now i have another problem, using this formula, i need it from cell A1 until cell H1, in the cell I1 gives me the error #N/D, in the cell I1 i want to do another formula, how can i remove the error, when i tried to delete it, it showed to me an message"impossible to modificate a parto of matrix" something like this

<TABLE style="WIDTH: 493pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=657 x:str><COLGROUP><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2592" width=81><COL style="WIDTH: 54pt" span=3 width=72><COL style="WIDTH: 54pt" width=72><COL style="WIDTH: 54pt" span=4 width=72><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 61pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl24 height=20 width=81 x:num="40778"></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl23 width=72></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 width=72></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 width=72 x:num></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 width=72></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 width=72></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 width=72 x:num></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl22 width=72 x:num></TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl25 width=72 x:err="#N/A"></TD></TR></TBODY></TABLE>