creating a VERY BASIC invoice system
Hi I've looked over the forum and tried searching, but alas, I couldn't find an entry or link to a really simple invoice system whereby I can create a template and when I fill in the total, this figure is displayed in a second sheet in the next available cell eg Invoice basically is Date - Ref - Client - GST - Total so the second sheet would take these 5 entries and place the cell contents in a single row (next available) Is this possible (easy or hard?) many thanks in advance -- hiker ------------------------------------------------------------------------ hiker's Profile: http://www.excelforum.com/member.php...o&userid=23871 View this thread: http://www.excelforum.com/showthread...hreadid=375138 |
Have you tried using MS Access.
Chris "hiker" wrote: Hi I've looked over the forum and tried searching, but alas, I couldn't find an entry or link to a really simple invoice system whereby I can create a template and when I fill in the total, this figure is displayed in a second sheet in the next available cell eg Invoice basically is Date - Ref - Client - GST - Total so the second sheet would take these 5 entries and place the cell contents in a single row (next available) Is this possible (easy or hard?) many thanks in advance -- hiker ------------------------------------------------------------------------ hiker's Profile: http://www.excelforum.com/member.php...o&userid=23871 View this thread: http://www.excelforum.com/showthread...hreadid=375138 |
i'm unclear as to what you are trying to do. do you want sheet 1 to have those blanks and you put them in and then those numbers are automatically populated in an invoice "archive" and then if you change the numbers on sheet1, the history will still stay there? if this is what you are trying to do, you can put a button on page 1 that after you enter the invoice information it copies those numbers into the second page as values, not as formulas. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=375138 |
All times are GMT +1. The time now is 09:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com