copying a row
 

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

copying a row
 

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

copying a row
 

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

copying a row
 

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.

copying a row
 

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

copying a row
 

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

copying a row
 

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