Hi

can anyone help?? i have a speadsheet that has 5 headings, name, save rate,
wrap time, aht, and notes! i am trying to copy a row to another sheet if in
notes it is equal to "action plan"

any ideas??

Easiest to use
Datafilterautofilterfilter the columncopy/paste.
If desired, record a macro and clean up.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" <james wrote in message
...
Hi

can anyone help?? i have a speadsheet that has 5 headings, name, save
rate,
wrap time, aht, and notes! i am trying to copy a row to another sheet if
in
notes it is equal to "action plan"

any ideas??

Hi Don

Thanks but i will have 10 different manager spreadsheets so this way would
take too much time! i am hoping that there is a formula that (if Note =
"ACTION PLAN" then copy the whole row to (action plan sheet)

does that make sence??

James

"Don Guillett" wrote:

Easiest to use
Datafilterautofilterfilter the columncopy/paste.
If desired, record a macro and clean up.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" <james wrote in message
...
Hi

can anyone help?? i have a speadsheet that has 5 headings, name, save
rate,
wrap time, aht, and notes! i am trying to copy a row to another sheet if
in
notes it is equal to "action plan"

any ideas??

On Jun 13, 9:01 am, james b wrote:
Hi Don

Thanks but i will have 10 different manager spreadsheets so this way would
take too much time! i am hoping that there is a formula that (if Note =
"ACTION PLAN" then copy the whole row to (action plan sheet)

does that make sence??

James

"Don Guillett" wrote:
Easiest to use
Datafilterautofilterfilter the columncopy/paste.
If desired, record a macro and clean up.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" <james wrote in message
...
Hi

can anyone help?? i have a speadsheet that has 5 headings, name, save
rate,
wrap time, aht, and notes! i am trying to copy a row to another sheet if
in
notes it is equal to "action plan"

any ideas??

I'd find using a quick Sort (then copy/paste) faster than Autofilter.
Otherwise, use an advanced filter in a macro.

You can't type a formula into one cell and get it to fill in a whole
set of data.

By spreadsheets do you mean workBOOKS or workSHEETS? Do you want to copy the
data from each worksheet to a summary worksheet. You didn't explain FULLY.
You can design a looping macro to do this for you.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" wrote in message
...
Hi Don

Thanks but i will have 10 different manager spreadsheets so this way would
take too much time! i am hoping that there is a formula that (if Note =
"ACTION PLAN" then copy the whole row to (action plan sheet)

does that make sence??

James

"Don Guillett" wrote:

Easiest to use
Datafilterautofilterfilter the columncopy/paste.
If desired, record a macro and clean up.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" <james wrote in message
...
Hi

can anyone help?? i have a speadsheet that has 5 headings, name, save
rate,
wrap time, aht, and notes! i am trying to copy a row to another sheet
if
in
notes it is equal to "action plan"

any ideas??

Hi Don

yes it's a worksheet! i have say 10 sheets plue then summary sheet. i want
to be able to search each sheet for notes = "action plan" then copy to the
summary sheet all the advisor's details! i know i can use filter or filter
advance but there must be a easier way!

i dont know much about marco's so all the help would be great!

"Don Guillett" wrote:


By spreadsheets do you mean workBOOKS or workSHEETS? Do you want to copy the
data from each worksheet to a summary worksheet. You didn't explain FULLY.
You can design a looping macro to do this for you.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" wrote in message
...
Hi Don

Thanks but i will have 10 different manager spreadsheets so this way would
take too much time! i am hoping that there is a formula that (if Note =
"ACTION PLAN" then copy the whole row to (action plan sheet)

does that make sence??

James

"Don Guillett" wrote:

Easiest to use
Datafilterautofilterfilter the columncopy/paste.
If desired, record a macro and clean up.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" <james wrote in message
...
Hi

can anyone help?? i have a speadsheet that has 5 headings, name, save
rate,
wrap time, aht, and notes! i am trying to copy a row to another sheet
if
in
notes it is equal to "action plan"

any ideas??

It may be easier for you to just send me your workBOOK along with snippets
of these emails on a sheet within the workbook. Send to the address below

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" wrote in message
...
Hi Don

yes it's a worksheet! i have say 10 sheets plue then summary sheet. i want
to be able to search each sheet for notes = "action plan" then copy to the
summary sheet all the advisor's details! i know i can use filter or filter
advance but there must be a easier way!

i dont know much about marco's so all the help would be great!

"Don Guillett" wrote:


By spreadsheets do you mean workBOOKS or workSHEETS? Do you want to copy
the
data from each worksheet to a summary worksheet. You didn't explain
FULLY.
You can design a looping macro to do this for you.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" wrote in message
...
Hi Don

Thanks but i will have 10 different manager spreadsheets so this way
would
take too much time! i am hoping that there is a formula that (if Note =
"ACTION PLAN" then copy the whole row to (action plan sheet)

does that make sence??

James

"Don Guillett" wrote:

Easiest to use
Datafilterautofilterfilter the columncopy/paste.
If desired, record a macro and clean up.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"james b" <james wrote in message
...
Hi

can anyone help?? i have a speadsheet that has 5 headings, name,
save
rate,
wrap time, aht, and notes! i am trying to copy a row to another
sheet
if
in
notes it is equal to "action plan"

any ideas??