Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with macro about data entry with double counter
Hi all,
I want to enter data in a new spreadsheet in the following manner: The first entry will be NF06046V01. The counter after the "V" will go up to 5. Then the counter 046 will be 047, and the counter after the "V" for this counter will start from "01" and go to "V05". Then we will go to raise the first counter by one again. until that first counter reaches to 300. i.e.The first 11 entries will be NF06046v01 NF06046v02 NF06046v03 NF06046v04 NF06046v05 NF06047v01 NF06047v02 NF06047v03 NF06047v04 NF06047v05 NF06048v01 .... Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Entry table | Excel Worksheet Functions | |||
Double entry problem | Excel Discussion (Misc queries) | |||
Double entry | Excel Discussion (Misc queries) | |||
Double entry lookup | Excel Worksheet Functions | |||
Double-click entry | Excel Programming |