Copy invoice dates to ledger
Closed
aneela1
Posts
2
Registration date
Monday November 23, 2015
Status
Member
Last seen
November 27, 2015
-
Nov 23, 2015 at 03:02 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 28, 2015 at 05:53 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 28, 2015 at 05:53 AM
Related:
- Copy invoice dates to ledger
- Cash book ledger software free download - Download - Billing and accounting
- Invoice and estimate software - Download - Billing and accounting
- How to activate facebook dating - Guide
- Snappy invoice system - Download - Billing and accounting
- Defcon dates - Guide
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Nov 24, 2015 at 12:24 AM
Nov 24, 2015 at 12:24 AM
Hello Aneela,
Could you please upload a sample of your work book so we can see exactly what you are trying to do. Change any sensitive data to dummy data.
You can upload a sample using a free file sharing site such as DropBox, ge.tt or SpeedyShare. Just post back with the link to the file.
Cheerio,
vcoolio.
Could you please upload a sample of your work book so we can see exactly what you are trying to do. Change any sensitive data to dummy data.
You can upload a sample using a free file sharing site such as DropBox, ge.tt or SpeedyShare. Just post back with the link to the file.
Cheerio,
vcoolio.
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Nov 28, 2015 at 05:53 AM
Nov 28, 2015 at 05:53 AM
Hello Aneela,
Firstly, as you have received help from someone else on another forum, then, to be fair to that person, you'll have to go back to that forum and complete your query there. This thread will hence be marked as Solved/Closed.
Secondly, I have quickly put something together for you which you may take back to the other forum. Its not tested but I have attached a link to a copy of your work book (Invoice) for you to see what can be done. The sample work book contains both Invoice and Ledger sheets ( I don't think that you need a work book for both). However, if you insist on two work books then, as you know how to access the second work book with the filepath code, you should be able to take it from there.
The sample work book copies the Invoice data to the next empty row in the Ledger sheet. It then clears the contents of the invoice form ready for any new entries. Thus, it will basically be a template which you can use over and over again. There is no need to create new sheets for this.
I hope that this at least leads you in the right direction. Following is the link:-
https://www.dropbox.com/s/yvikqhmk0ypgyix/Aneela.xlsm?dl=0
The code is in Module 1.
Good luck with it all.
Cheerio,
vcoolio.
Firstly, as you have received help from someone else on another forum, then, to be fair to that person, you'll have to go back to that forum and complete your query there. This thread will hence be marked as Solved/Closed.
Secondly, I have quickly put something together for you which you may take back to the other forum. Its not tested but I have attached a link to a copy of your work book (Invoice) for you to see what can be done. The sample work book contains both Invoice and Ledger sheets ( I don't think that you need a work book for both). However, if you insist on two work books then, as you know how to access the second work book with the filepath code, you should be able to take it from there.
The sample work book copies the Invoice data to the next empty row in the Ledger sheet. It then clears the contents of the invoice form ready for any new entries. Thus, it will basically be a template which you can use over and over again. There is no need to create new sheets for this.
I hope that this at least leads you in the right direction. Following is the link:-
https://www.dropbox.com/s/yvikqhmk0ypgyix/Aneela.xlsm?dl=0
The code is in Module 1.
Good luck with it all.
Cheerio,
vcoolio.
Nov 27, 2015 at 01:23 PM
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(when the current one is full)
b. add another worksheet to the workbook ledger for new copying and rename the current sheet.
3. Filter the ledger sheets as per the dates specified by user, say 1 April 2015 to 14 June 2015 or 10 June 1999 to 09 Dec 2010. Any random dates, but it should give the data within the specified dates and print with the headers(just as on a single sheet of ledger).
The files are available at:
https://www.dropbox.com/s/qhsh6x7e2g2fld2/invoice.xlsm?dl=0
https://www.dropbox.com/s/2pzhdbodsbur227/Ledger.xlsx?dl=0
This has not been cross-posted at https://www.excelguru.ca/forums/showthread.php?5193-Excel-Vba-copy-list-of-entries
Thank you
Truly,
Aneela