Hi!
i am trying to copy data of certains rows from 2 columns that match the
criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
DATE,but i want to copy column CUST & MOD to another worksheet.can it be done?
i've tried to use advanced filter,but it seems like copy DATE column
only,cannot copy CUST & MOD.
is there any other suggestion?
thanks in advance=)

--
Regards,
Linda

Take a look a VLOOKUP function in Help menu


"linda" wrote:

> Hi!
> i am trying to copy data of certains rows from 2 columns that match the
> criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
> DATE,but i want to copy column CUST & MOD to another worksheet.can it be done?
> i've tried to use advanced filter,but it seems like copy DATE column
> only,cannot copy CUST & MOD.
> is there any other suggestion?
> thanks in advance=)
>
> --
> Regards,
> Linda

thanks for repply..i've try that but VLOOKUP only return a single
value.moreover,the 2 columns i need is not side by side.

--
Regards,
Linda


"Teethless mama" wrote:

> Take a look a VLOOKUP function in Help menu
>
>
> "linda" wrote:
>
> > Hi!
> > i am trying to copy data of certains rows from 2 columns that match the
> > criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
> > DATE,but i want to copy column CUST & MOD to another worksheet.can it be done?
> > i've tried to use advanced filter,but it seems like copy DATE column
> > only,cannot copy CUST & MOD.
> > is there any other suggestion?
> > thanks in advance=)
> >
> > --
> > Regards,
> > Linda

Hi Linda

Advanced Filter should work for you.

On the destination sheet, enter in cells A1 and B1 the column headings that
you are interested in from the source sheet.
In A2 and B2 enter the criteria that must be matched to select the rows.

Then, starting from the destination Sheet, Data>Filter>Advanced Filter>Copy
to another location
List range> Select the complete range of data from your source sheet
Criteria range> cells A1:B2 of your destination sheet
Copy to> Select A4:M4 of your destination sheet

I have used M4 in my example. Ensure the column letter chosen is enough to
include all the columns of data you want extracted from the source.

For more help on advanced filter take a look at
http://www.contextures.com/xladvfilter01.html#ExtractWs
--
Regards
Roger Govier



"linda" <(E-Mail Removed)> wrote in message
news:31DDA414-D85E-4E82-9B87-(E-Mail Removed)...
> Hi!
> i am trying to copy data of certains rows from 2 columns that match the
> criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
> DATE,but i want to copy column CUST & MOD to another worksheet.can it be
> done?
> i've tried to use advanced filter,but it seems like copy DATE column
> only,cannot copy CUST & MOD.
> is there any other suggestion?
> thanks in advance=)
>
> --
> Regards,
> Linda

thanks Roger!its work=)

--
Regards,
Linda


"Roger Govier" wrote:

> Hi Linda
>
> Advanced Filter should work for you.
>
> On the destination sheet, enter in cells A1 and B1 the column headings that
> you are interested in from the source sheet.
> In A2 and B2 enter the criteria that must be matched to select the rows.
>
> Then, starting from the destination Sheet, Data>Filter>Advanced Filter>Copy
> to another location
> List range> Select the complete range of data from your source sheet
> Criteria range> cells A1:B2 of your destination sheet
> Copy to> Select A4:M4 of your destination sheet
>
> I have used M4 in my example. Ensure the column letter chosen is enough to
> include all the columns of data you want extracted from the source.
>
> For more help on advanced filter take a look at
> http://www.contextures.com/xladvfilter01.html#ExtractWs
> --
> Regards
> Roger Govier
>
>
>
> "linda" <(E-Mail Removed)> wrote in message
> news:31DDA414-D85E-4E82-9B87-(E-Mail Removed)...
> > Hi!
> > i am trying to copy data of certains rows from 2 columns that match the
> > criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
> > DATE,but i want to copy column CUST & MOD to another worksheet.can it be
> > done?
> > i've tried to use advanced filter,but it seems like copy DATE column
> > only,cannot copy CUST & MOD.
> > is there any other suggestion?
> > thanks in advance=)
> >
> > --
> > Regards,
> > Linda
>
>
>