Need Help on AutoMating an Autofill Column

[VAST39]

Hi guys,

I have a spreadsheet that imports data from an Access database. They would like the spreadsheet to automatically create a column which numbers each record for the printout in sequencial order.


So if I import a set that has 20 records, I would have the number column like

COUNT
1
2
3
4
5
6
7
8
9
and so on...

I know I can do this manually with autofill, but I want to automate this process. I thought I could record a macro of doing the autofill ,but since the data sets have different number of records, this won't work either. I need the autofill to only count down to the number of records that I'm importing. Is there anyway to do this?

 

[SkipVought]

Hi,

"imports?"

How? Via Data > Get external data...?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]