» Sizing Charts with the Window in Microsoft Excel.

Hi - is there anyway I can create an excel Template, it may be an invoice
quote letter etc. What I need it to do is generate a sequential number
somewhere, eg: say 1000. When I open that template again - I want that
number to be 1001. It doesnt really matter if I dont end up saving that one,
and close it so the next person to open that template will be 1002. As long
as no number is repeated.

Hi JJ,

Yes - you can do this, but how you do it depends on how many people are creating the documents, and where they are stored after creation.

Your options include:

1) Using VBA to pick up the last (or next) number to be used, inserting it in your document, and then incrementing the counter.

The counter could be in a file on your HDD or network, or even in your registry.

2) You could add a sheet each time for a new document (all in one file), and use a formula to refer to the last document, or even use the MAX function and add one.

3) You could create a new file and pick up the number by linking to the previous file in the same folder (probably).

Lots of options - you need to decide how it would work from a business perspective first, then apply the appropriate technical solution to fit the business process.

Alan.

I created my macro to extract csv data dump in excel worksheet. TAkes the first two columns copy paste to sheet 1. TAkes those to columns creates chart. How can I go back and play with my macro chart so that it can increase the size of the chart and decrease fonts for better viewing.