Automate fill down

  • Thread starter Thread starter Lorrie
  • Start date Start date
L

Lorrie

Need some help to fill down:

Example:

-A- -B- -C- -D-
Account No. Check No. Name Address
123-0001 1234 John Doe 1234 Anywhere USA
1256 Mary Smith 1520 There Street
1298 Harry Soso 1001 Post Street
123-0065 1299 Jack Sprat 480 Queen Avenue
1243 Jill JOnes 512 Harrold Way

This sounds simple because all I need to is fill the
account number down to the bottom of each account entry
and then go on to the next. But, each account has been
500 and 2500 entries before the next account number pops
up and there are approximately 50,000 pages. Can any one
help with a solution?
 
1. Select your range in column A.
2. Press F5.
3. Special > Blanks > OK.
4. Press "=" and click on the first cell in your range.
5. Press <ctrl><enter>.

HTH
Jason
Atlanta, GA
 
Lorrie

Before I attempt a solution, you should be informed of the following.

Given your size estimates of "500 and 2500 entries before the next
account number pops up and there are approximately 50,000 pages" I
think that excel's limit of 65536 rows per worksheet will be easily
exceeded.

Is there a reason that you want to use excel?
I think that a database app like MSAccess may be more suitable given
the volumes.
 
The information is already in an Excel file. It is being
converted to another program and the fill down in
necessary for the conversion.
 
-----Original Message-----
There are instructions here for filling blank cells:

http://www.contextures.com/xlDataEntry02.html



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.
I appreciate your help, but I have hundreds and possibly
Click to expand...
thousands of pages to do in one day (on the first of the
month) I need to automate this process as I will not have
time to go through each and every page and search for new
numbers and then repeat this F5, blanks thing. Do you
know of a way to automate it so that the program goes
down column A looking for the next number and replacing
everything above.
 
Despite the good answer, it's a good warning.

Excel was never designed with security in mind. It should be reserved for
small jobs that won't crash a company if you wipe out a formula by stroking
the keyboard with your shirt sleeve.

Having said that, buying ready-made software that does just the job you want
seems to be as difficult as it has always been, and practically impossible
if your company is big enough to have an IT department.... :-(

Regards
 
Back
Top