Excel VBA receipt printing and storing data

A file with two sheets in order to print and save receipts.

One sheet is the receipt form where I will manually fill in customer data and sum paid.

I need a macro which will:

-print the form

-copy receipt data on the next free row of another sheet (receipt log file)

-lock all data above that line

-clear receipt form

-increase receipt number by 1

-save the worksheet

Evner: Excel, Visual Basic

Se mere: excel button to print specific sheets, how do i create a print macro in excel?, excel print macro multiple sheets, vba code for print button in excel, excel vba save invoice data, excel print button without macro, how to print data in excel using vba, excel macro print selection, excel vba button to load data from csv, excel vba code read serial data, excel vba code download historical data yahoo, excel vba download yahoo financial data, excel vba create chart display data, excel vba example read cvs data, excel vba chart click show data, excel vba code pull internet data, search data csv excel vba, getting data msaccess excel vba, vba excel pop gui user input data, excel vba look data sheet

Om arbejdsgiveren:
( 1 bedømmelse ) Athens, Greece

Projekt ID: #17123168

Tildelt til:


Hi, The requirements all seem clear, just a few questions: -"lock all data above that line" - no chance that you want to change an earlier receipt later? - do you allow me to remove the grey coloring outside of Flere

€120 EUR in 2 dage
(100 bedømmelser)

10 freelancere byder i gennemsnit €106 på dette job

€250 EUR in 3 dage
(52 bedømmelser)
€100 EUR på 1 dag
(121 bedømmelser)

I have excellent command on MS Excel and can create a macro as per your requirements. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place Flere

€80 EUR på 1 dag
(43 bedømmelser)

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in I Flere

€100 EUR in 3 dage
(14 bedømmelser)

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do Flere

€90 EUR in 3 dage
(35 bedømmelser)

Hello, I went thru the description This can be done and I have done similar to this project If you want to save that invoice as a separate pdf as per the invoice no, also possible Contact me, I will do a perf Flere

€88 EUR in 2 dage
(19 bedømmelser)

Hello, I am interested in helping you with your project, I can create the VBA code that you need for your receipt, all your requirements can be perfectly implemented. I am an expert in Excel / VBA. We can discuss more Flere

€55 EUR in 2 dage
(14 bedømmelser)

Hi, I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Please let me know if your interested, I will gladly help you. Thanks, Marlou

€111 EUR in 2 dage
(4 bedømmelser)

Hi bro I have read your requirements very carefully. So this project is very interesting and simple for me. I can finish it in time clearly. I am an experienced and skillful vb.net and excel developer. I have rich Flere

€70 EUR på 1 dag
(1 bedømmelse)