Hi,
Thanks to p45cal , I am have done with my excel sheet.
This is a new thread:Please help with the following:
1. invoice.xlsm has 15 rows where user can enter the data to be copied to ledger.xlsx, but if there are less than 15 items on the invoice, say 10 or 2, it still copies the data for 15 entries onto the ledger.Please help with that,i.e it should copy data for the cells that are not empty and leave the empty ones.
2. The number of rows in Column D for ledger.xlsx is 32(for A4 printing). Please could you:
a. ask the user to print the current worksheet(which is full)
b. add another worksheet to the workbook ledger for new copying and rename the current sheet.
This has not been cross-posted elsewhere.
Thank you
Truly,
Aneela
Thanks to p45cal , I am have done with my excel sheet.
This is a new thread:Please help with the following:
1. invoice.xlsm has 15 rows where user can enter the data to be copied to ledger.xlsx, but if there are less than 15 items on the invoice, say 10 or 2, it still copies the data for 15 entries onto the ledger.Please help with that,i.e it should copy data for the cells that are not empty and leave the empty ones.
2. The number of rows in Column D for ledger.xlsx is 32(for A4 printing). Please could you:
a. ask the user to print the current worksheet(which is full)
b. add another worksheet to the workbook ledger for new copying and rename the current sheet.
This has not been cross-posted elsewhere.
Thank you
Truly,
Aneela