I have 2 Worksheet
1. Invoice
2. Sales
I want to copy these cells from Sheet Invoice
Cell F1 i.e Invoice No
Cell F37 i.e Invoice Total Amount
Cell F38 i.e Payment Received
Cell F39 i.e Due Amount
To Sales Sheet on Column A, B, C & D respectively and then clear the Sheet for next entry.
Can you help me out with the VBA code for this.
Bookmarks