Try this:
--
The views expressed are my own, and not those of my employer or anyone
else associated with me.
My current valid email address is:
(e-mail address removed)
This is valid as is. It is not munged, or altered at all.
It will be valid for AT LEAST one month from the date of this post.
If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.
The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:
ewygchvboocno43vb674b6nq46tvb
Carol F. said:
I have a spreadsheet with a customer number on line 1, with
additional data
about this customer on lines 2-6 (customer column on these lines is
blank).
I then have a new customer number on line 7, with additional data
about this
second customer on lines 8-12 (custom column on these lines is
blank). This
spreadsheet has thousands of such entries.
I am hoping to find a command that will allow me to fill in the
custom
number from line 1 down until I find the next custom number already
filled;
then take the new customer number and fill it down until I find the
next
customer number, etc. Do you know of a command that will help me?
If I have understood correctly, try this:
0) Backup your workbook(s) nd read all the steps below before
beginning.
1) Autofilter the entire range / sheet
2) Filter 'Customer Column' to show only blank cells (I'll assume this
is column A)
3) Enter a formula in the first cell now showing to refer to the cell
above. For example if you have a customer number in A1 then A7, you
will be seeing A2:A6,A8:A13 etc. In A2 enter "=A1" (without the
quotes).
4) Copy this and paste down the entire range, but make sure that you
choose the option to 'select visible cells only'. This can be put on
a toolbar from the 'EDIT' list if you like: Tools - Customise -
Commands - Edit - Scroll to bottomn of list - Drag 'Select Visible
Cells' to any tool bar you have visible.
That should do it.
HTH,
Alan.
--
The views expressed are my own, and not those of my employer or anyone
else associated with me.
My current valid email address is:
(e-mail address removed)
This is valid as is. It is not munged, or altered at all.
It will be valid for AT LEAST one month from the date of this post.
If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.
The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:
ewygchvboocno43vb674b6nq46tvb