Excel VBA receipt printing and storing data

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

Excel Visual Basic

Project ID: #17123168

About the project

9 proposals Remote project Active 5 years ago

Awarded to:

kolosibalint

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 More

€120 EUR in 2 days
(123 Reviews)
6.9

9 freelancers are bidding on average €110 for this job

supper5guy

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 More

€90 EUR in 3 days
(83 Reviews)
5.8
archanaoswal

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 More

€80 EUR in 1 day
(89 Reviews)
6.0
vaidyag

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 More

€100 EUR in 3 days
(15 Reviews)
5.3
nelumindralal

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 More

€88 EUR in 2 days
(25 Reviews)
4.3
robcastillo

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 More

€55 EUR in 2 days
(15 Reviews)
3.5
marloufin

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 days
(6 Reviews)
4.1