Hi
I have no experience with VBA at all & have spent hours on the web trying to find out how to do something I imagine is very simple...
I have 3 sheets in a workbook named "General Invoice", "Itemised Invoice" & "Drop Down Lists". On "General Invoice" & "Itemised Invoice" I want to generate the same invoice number in cell D3. I have used this code to generate an invoice number & clear contents (following a podcast by Mr Excel) which I have attached to a shape:
Sub NextInvoice()
Range("D3").Value = Range("D3").Value + 1
Range("A10:C21").ClearContents
End Sub
However it only updates the cell D3 on the sheet the shape is pasted in, not both sheets. How do I make it update both sheets at same time?
Also how do I clear the contents in cells A4,A6 & A10:C21 on "itemised Invoice" but on "General Invoice" I want to clear A4,A6 & A10:D21 instead?
Thank you.
Bookmarks