Macro Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try doing a Google Search; excel sub invoice
and a Google Groups Search: group:*excel* sub invoice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Worksheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I automatically generate a worksheet. 1
Creating A List of Items Between Two Numbers 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA / Macro Help Please 2
Creating a list of info in A1 cell in multiple worksheets 4
Function to put worksheet name in cell returns text, need number 5

Back
Top