Dear All,
I have a table MASTER to enter all my vouchers. (This is in sheet "MASTER")
I will take orders separately in tables one table per order. (These tables will be in sheet "ORDERS")
Once the order is completed, I will transfer/add it's data to [MASTER] table and want VBA to do the same.
When we started macro, A form with below fields to be appeared.
1. SOURCE 2. REF NO 3. DATE 4. PARTY 5. DORC
(Here SOURCE is the Order Table Name)
I will fill all the fields and submit.
Now the Macro Functions are,
1. Count the data rows in Source/Order Table (assume that it is N)
2. A value " SALES " be filled N times to the end of MASTER[TYPE] column
3. Given DATE value be filled N times to the end of MASTER[DATE] column
4. Given REF NO value be filled N times to the end of MASTER[REF NO] column
5. Given PARTY value be filled N times to the end of MASTER[PARTY] column
6. SOURCE[P CODE] total column to be pasted @ MASTER[P CODE] end
7 SOURCE[QTY] total column to be pasted @ MASTER[QTY] end
IF DORC value in form is DEBIT then
8. SOURCE[TOTAL] total column to be pasted @ MASTER[DEBIT] end ELSE
8. SOURCE[TOTAL] total column to be pasted @ MASTER[DEBIT] end & MASTER[CREDIT] end too
Please find the attachment.
Thanks in advance.
Bookmarks