populating a work sheet from excel based Closed

Question

Hello, 

I need your guidance please: I've got a tall order :) I hope you can help me! 

I am trying to have a new worksheet created from a template when I type information in a cell. 
For example, If I fill in the invoice form invoice , I want it to create a work sheet in the second tab form the information I just typed in the invoice. I also want the invoice number to regenerate every time I print the invoice.

Thank you in advance

TrowaD · Answer

Hi Melissa,

What I understand from your query is that you manually fill in an invoice and after you print the invoice, clear the entered fields and increase the invoice number by 1.

Is this correct?

Also could you upload your file using a file sharing site like www.speedyshare.com or ge.tt and post back the download link (careful with sensitive information), for a better understanding of your lay out? 

Best regards,
Trowa

melissa · Answer

Hello Trowa

that's correct.

I up loaded it - link is http://speedy.sh/a37Gb/HU.xls

thank you for helping!

TrowaD · Answer

Hi Melissa,

Not sure which ranges need to be cleared, but you can add ranges yourself.

Also not sure how you want your order number to look like. Now it's a single number, which will increase by 1 every time the code is run.

Here is the code:
Sub ClearForm()
Range("D3:I3,E4:I4,E5:I7,E8:F10,H8:I8,I9,C18:I30").ClearContents
Range("H9") = Range("H9") + 1
End Sub  

Let us know if further assistance is desired.

Best regards,
Trowa

Populating a work sheet from excel based

3 responses

Similar discussions

Subscribe To Our Newsletter!