Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Autofill question
1 view
Skip to first unread message
Gor_yee
Nov 12, 2009, 3:23:59 AM11/12/09
to
Hi there...I need a VBA script that I can use to autofill down a
column...so if row a5 had a heading of "happy" and then z5 had a
heading of sad... I need that script to fill down from a5 to y5 with
Happy and then from z5 fill down to the next heading with Sad...
column...so if row a5 had a heading of "happy" and then z5 had a
heading of sad... I need that script to fill down from a5 to y5 with
Happy and then from z5 fill down to the next heading with Sad...
can you help??
Dave Peterson
Nov 12, 2009, 8:37:26 AM11/12/09
to
I'm not sure I understand, but maybe the techniques (code and manual) at Debra
Dalgleish's site will help:
Dalgleish's site will help:
http://contextures.com/xlDataEntry02.html
and a video
http://www.contextures.com/xlVideos01.html#FillBlanks
--
Dave Peterson
Gord Dibben
Nov 12, 2009, 5:53:00 PM11/12/09
to
I think you should try again to describe what you need.
You cannot fill down from A5 to Y5 since that is the same row.
You can fill across if that's what you want.
Gord Dibben MS Excel MVP
On Thu, 12 Nov 2009 00:23:59 -0800 (PST), Gor_yee <jonni...@gmail.com>
wrote:
0 new messages