Excel Data,VB and Automatic serial Number

[sarjeel.faki]

We've own format for Excel some data include like ,date,amount and description , we'd like to create same data after save button click it should go another sheet and autmatically generate serial number and print as well.
1button - Save & print ( it will give invoice number, save to another sheet and print .
What will be the code for above content ?

 

[vletm]

sarjeel.faki
If You would keep Your own format
... then how other could keep it same
... without even a sample Excel-file? ... how?
As You've read Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

How to get the Best Results at Chandoo.org
>>> For the best/fastest results, Upload a Sample File
It should show layouts, sample data as well as expected results.

 

[sarjeel.faki]

sarjeel.faki
If You would keep Your own format
... then how other could keep it same
... without even a sample Excel-file? ... how?
As You've read Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

How to get the Best Results at Chandoo.org
>>> For the best/fastest results, Upload a Sample File
It should show layouts, sample data as well as expected results.

Apologies, i attached sample data format,
Automatic serial number once get print & save( it will store in another data sheet)

 

[vletm]

sarjeel.faki
#1 Cell H8 (PCV #) comment has text seriel number date+ any another 3 digit
Your sample value is 202111-0001 ... something don't match or how?
#2 Amount ... Do You want only value to copy?
#3 Save & print ( it will give invoice number,...
Where is Your used invoice number?
... which should give while copy.
... if there are 20 rows data, do all rows have same ... invoice number or what?
#4 Please, check Your file one more time.

 

[sarjeel.faki]

Please find my comments :

#1 Cell H8 (PCV #) comment has text seriel number date+ any another 3 digit= seriel number should be minimum 6digit number
Your sample value is 202111-0001 ... something don't match or how? = ignore this point (you can use eg. xxxxxx for serial number)
#2 Amount ... Do You want only value to copy? = for amount left as its
#3 Save & print ( it will give invoice number,...
Where is Your used invoice number? = PCV its called as refrence number/ invoice number
... which should give while copy.
... if there are 20 rows data, do all rows have same ... invoice number or what? yes its for all.
#4 Please, check Your file one more time.