Adding Data Automatically

B

BlackJackal

I am importing data automatically into a spreadsheet from a database
and I need to give serial numbers to each row of data. So for example
I am importing in a bunch of product data such as product number
description etc. from a database. I want to know how to automatically
add a sequential serial number into another column for the number of
rows imported in. So the final resut woult look something like this


Product Number Description Serial number
3849284 Waffle Iron 10000
8489298 Skillet 10001

So on and so forth with the serial number column increasing for each
row of data imported.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Created automatically sequence numbers 7
Linking Tables 3
Getting Access data to work in Excel formulas 3
Best way to get data from Access 2003 to Excel 2003 6
If this is impossible, just tell me. 7
serial number needs to change automatically 4
Reorganising Data 3
After checked condition, add the data to adjacent cell automatically 8

Top