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.


--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73900

adib;264781 Wrote:
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.adib, do you have a sample workbook you could upload?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73900

Dear Simon Lloyd,

Please check the attached file and help me out .
Thanks


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

--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73900

Hi,

Please refer to Advanced Filters in Excel's Help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"adib" wrote in message
...

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.


--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73900

adib;264781 Wrote:
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.
Do you want the data with gaps between them like your example or would
you like them one under the other?, do you want a only a formula based
answer or will you accept VBA too?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73900

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|
+-------------------------------------------------------------------+

--
adib
------------------------------------------------------------------------
adib's Profile: http://www.thecodecage.com/forumz/member.php?userid=165
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73900