Egad. Well, first off, I'd suggest splitting the document up if you can. The chances Excel will crash on all those records is pretty good.
Next, you'll need to use VBA I think. Do you know any VBA? I am guessing you probably don't. Anyway, I can't go into it all here, but I'd suggest you snag a local with some VBA skills and then point him or her to this:
http://www.automateexcel.com/index.php/2004/08/14/excel_vba_macro_to_autofill
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
Click on the "Insert" tab at the top of the document.
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
216 views
Usually answered in minutes!
How are you autofilling it?
×