Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Data Automatically
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Data Automatically
=IF(A1<"",--TEXT(ROW(1:1)+9999,"######"),"")
"BlackJackal" skrev: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Data, automatically adding new row | New Users to Excel | |||
Summarize Data and automatically update including adding rows | Excel Discussion (Misc queries) | |||
adding data series automatically | Charts and Charting in Excel | |||
How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
Automatically Adding Data to Charts | Charts and Charting in Excel |