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