Help for marco to autofill in down the row
 

I've found a solution for the above topic he
http://groups.google.com/group/micro...56eb8a4439d580


however the instruction on using the F5 is not clear to me and is not
working for me. Can anyone clarify this for me?

Help for marco to autofill in down the row
 

I didn't look at the link but f5gotoSPECIAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"S Himmelrich" wrote in message
...
I've found a solution for the above topic he
http://groups.google.com/group/micro...56eb8a4439d580


however the instruction on using the F5 is not clear to me and is not
working for me. Can anyone clarify this for me?

Help for marco to autofill in down the row
 

F5 Special, then what...?

Help for marco to autofill in down the row
 

thank you for your response.
F5, special - then what....I've seen similar postings, but I'm not
clear on what to do next.

Scott



On Mar 19, 3:35*pm, "Don Guillett" wrote:
I didn't look at the link but f5gotoSPECIAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"S Himmelrich" wrote in message

...



I've found a solution for the above topic he
http://groups.google.com/group/micro...orksheet.funct...

however the instruction on using the F5 is not clear to me and is not
working for me. *Can anyone clarify this for me?- Hide quoted text -

- Show quoted text -

Help for marco to autofill in down the row
 

Select the column.

F5SpecialBlanksOK

Type an = sign in the active blank cell then arrow up or point to cell above.

Hit CTRL + ENTER keys.

With the column still selected, copy then paste special(in place)valuesokesc

You're done.


Gord Dibben MS Excel MVP


On Fri, 21 Mar 2008 09:34:42 -0700 (PDT), S Himmelrich
wrote:

thank you for your response.
F5, special - then what....I've seen similar postings, but I'm not
clear on what to do next.

Scott



On Mar 19, 3:35*pm, "Don Guillett" wrote:
I didn't look at the link but f5gotoSPECIAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"S Himmelrich" wrote in message

...



I've found a solution for the above topic he
http://groups.google.com/group/micro...orksheet.funct...

however the instruction on using the F5 is not clear to me and is not
working for me. *Can anyone clarify this for me?- Hide quoted text -

- Show quoted text -