sheet 1 to sheet 2 conditional

[adib]

Hi,on sheet 2 =if (sheet1!a3=USA) then i want to copy all data next to
usa there is 5 colum b3,c3,d3,e3 or entire row on sheet 2. what kind of
formula do i use.for this i used in cellc3
=IF(sheet1!A3="usa",sheet1!C3,"") in cell d3
=IF(sheet1!A3="usa",sheet1!d3) and in all next cell.Please find out
there is any easy way.
Thanks.

 

[Simon Lloyd]

Hi,on sheet 2 =if (sheet1!a3=USA) then i want to copy all data next t
usa there is 5 colum b3,c3,d3,e3 or entire row on sheet 2. what kind o
formula do i use.for this i used in cellc
=IF(sheet1!A3="usa",sheet1!C3,"") in cell d
=IF(sheet1!A3="usa",sheet1!d3) and in all next cell.Please find ou
there is any easy way
Thanks.adib, do you have a sample workbook you could upload

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[adib]

Dear Simon Lloyd,

Please check the attached file and help me out .
Thank

+-------------------------------------------------------------------
|Filename: ACC BOOK.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=97
+-------------------------------------------------------------------

 

[Ashish Mathur]

Hi,

Please refer to Advanced Filters in Excel's Help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Simon Lloyd]

Hi,on sheet 2 =if (sheet1!a3=USA) then i want to copy all data next t
usa there is 5 colum b3,c3,d3,e3 or entire row on sheet 2. what kind o
formula do i use.for this i used in cellc
=IF(sheet1!A3="usa",sheet1!C3,"") in cell d
=IF(sheet1!A3="usa",sheet1!d3) and in all next cell.Please find ou
there is any easy way
Thanks

Do you want the data with gaps between them like your example or woul
you like them one under the other?, do you want a only a formula base
answer or will you accept VBA too

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[adib]

Dear Simon Lloyd
i don't want gaps between them i sent the example only to show you what
i did. i kept this because if i enter new data to ccc it will come to
ccc sheet that's all.please see the attachement what actual i
need.please suggest me what is best for me ,formula or VBA. I hope you
will find out what i want.
Thanks


+-------------------------------------------------------------------+
|Filename: ACC BOOK.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=98|
+-------------------------------------------------------------------+