We Need help for VBA Query : Query: I will make invoice every day, understand my invoice system “ i was make first invoice, next time make need next invoice this time i was move as copy sheet & rename sheet manually………. I will try to automatically get Name from active invoice sheet … Example : A11 = invoice Number A16 = Party Name We Need automatically rename sheet according invoice no & party name Ex: EXP-001_Swara Foods ( i will move as copy sheet & assign Invoice number and party name ) After change Automatically renamed sheet How it possible ?????? Please help sir !!!
Thank you my friend you save us a lot of time God bless you
Happy to help
We Need help for VBA Query :
Query: I will make invoice every day, understand my invoice system
“ i was make first invoice, next time make need next invoice this time i was move as copy sheet & rename sheet manually……….
I will try to automatically get Name from active invoice sheet …
Example :
A11 = invoice Number
A16 = Party Name
We Need automatically rename sheet according invoice no & party name
Ex:
EXP-001_Swara Foods
( i will move as copy sheet & assign Invoice number and party name )
After change Automatically renamed sheet
How it possible ??????
Please help sir !!!
Why to create excel sheet for every invoice?
For copy any how you will invoice print out/u can save pdf
Very Good Info.
Thank You.
Glad it was helpful!
Useful
Glad you think so!