Correcting macro consecutive numbering

[Berna11]

Good evening
I need help to change the macro provided below.
Every month I run this macro and update me H4-H7 automatically about 200 files I open down.
The amendment, if possible, in cell H4 find this last invoice number "Unw2016 / 06526" I wish with each open file increases I numbering automatically then becomes "Unw2016 / 06527" other files "Unw2016 / 06528" other files "Unw2016 / 06529 ".... to all open files.
Thanks so much

Please Login or Register  to view this content.

[Richard Buttrey]

If you're saying that every time you open another file - presumably with a macro which you don't show, you wish to increment the number then you need to create a Variable and use it to increment the invoice number every time you open another file. Normally I'd suggest a Public VBA Variable but since you will want to keeo incrementing the number in succeeding months then I suggest you hold then variable in a named cell called say "InvoiceNo"

Put the value 6526 in the named cell. Then in the macro that opens the file add

Please Login or Register  to view this content.

Then in your macro1 use

Please Login or Register  to view this content.

Note you don't need all the .Select stuff in your macro. Just use the same sytax for H5:H7 as the above. And rather than hard code stuff like "10/05/2016") in the macro, create a variable in the workbook somewhere and use that so that you don't need tio edit the macro every month.

[Berna11]

thank you Richard for your kindness
I understand what you say but do not know how to apply it.
I am attaching the file with the macro.
when I open the file I open all the other 200 and I varies on all the H4-H7 cells
but the cell H4 would like with the numbers to each file, and so I was all the same number.

[Richard Buttrey]

I'm confused by your mention of opening 200 files.

Do you mean that you want every file you open to have its H4 invoice number incremented automatically at the time you open the file?

If that's the case then use the Workbook Open event macro in each of the 200 files. i.e.

Please Login or Register  to view this content.

Alternatively, if you want to avoid having to add the macro to all 200 workbooks then you could create a Module level Procedure with the same code in your Personal Workbook, and then run that procedure when you've opened a file.

[Berna11]

the files are all open with everyone in H4 brings an old invoice number.
With the macro is automatically added to all files in the H4 first valid number of the month .. 06526.
I would like that the first file open ports 06526 on the second file ..06527 the third ..06528 files etc ...
if possible