Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transfer / combining Excel data
I have a data worksheet created in excel with a column containing 5 digit
serial numbers, up to 300 diferent serial numbers (in individual rows). I have the data sorted in assending order based on serial number column. Serial numbers are random and not consecutive (ie. 05943, 05944, 05945, 05968, 05988 etc..) 1) I need to be able to select all the serials and transfer them to another worksheet in excel, placing them in one cell, table, or ? - for purpose of issuing a certification to our customer listing all the serial shipped- is this possible? 2) If they can be in be transfered, is there a formula that would list them in ranges instead of all 300 serial numbers? (ex. 05943 thru 05945, 05968, 05988 thru 06112 etc...) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I look up data in a different workbook in an excel spread. | Excel Worksheet Functions | |||
Moving blocks of data in excel | Excel Discussion (Misc queries) | |||
Copy data between 2 instances of Excel | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
insert data from one excel file into another | Excel Discussion (Misc queries) |