| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connecting information on different spreadsheets
I am trying to integrate a system whereby we will allocate a the next number
in a sequence to the next unique item added to ANY of 4 separate spreadsheets. The individual spreadsheets will have a name and unique code number - I would like to be able to use a master spreadsheet to then allocate a sequential number according to when they were added to the individual spreadsheets. Is this possible? Lynne Murray |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Connecting information on different spreadsheets
What you are looking for requires the use of macros. Here is a link to a
solution for you... http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- HTH... Jim Thomlinson "Lmurraz" wrote: I am trying to integrate a system whereby we will allocate a the next number in a sequence to the next unique item added to ANY of 4 separate spreadsheets. The individual spreadsheets will have a name and unique code number - I would like to be able to use a master spreadsheet to then allocate a sequential number according to when they were added to the individual spreadsheets. Is this possible? Lynne Murray |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alert messages, running totals, connecting spreadsheets or cells | Excel Discussion (Misc queries) | |||
| Connecting data between 2 spreadsheets | Excel Worksheet Functions | |||
| Combining information from 2 Spreadsheets into 1 | Excel Discussion (Misc queries) | |||
| Connecting Linked Spreadsheets | Excel Discussion (Misc queries) | |||
| Combine information about products from 2 spreadsheets | Excel Worksheet Functions | |||
Linear Mode
