Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
I have a spreadsheet that contains two worksheets. One is the contents page
and the other is a template. The template has a command button when pressed creates a new worksheet. The new worksheets are allocated a number in sequence. Each time a worksheet is created from the template I would like it to 1) create a order number 06/775 and put this into cell A1 on worksheet 1. The order number in cell A1 is updated each time a worksheet is created. 2) put the order number into cell C7 in the contents worksheet. 3) when worksheet 2 is created update the order number in cell A1 to 06/776. 4) put the order number into cell C8 in the contents worksheet If this is possible any help is appreciated. Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |