copying a row

  • Thread starter Thread starter james b
  • Start date Start date
J

james b

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
Data>filter>autofilter>filter the column>copy/paste.
If desired, record a macro and clean up.
 
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
 
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
Click to expand...

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.
 
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!
 
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
 
Back
Top