Em Andamento

Generate Receipt from data in a Google Sheet

I have a google sheet contains data for an auction I am holding over the weekend. The spreadsheet contains Buyer/Bidder information (e.g. name, address, phone number, etc) AND sale item information (e.g. item number, description, sale price, winning bidder number, etc).

The google sheet I have setup contains 2 sheets within. The first sheet (sheet1) contains all the buyer/bidder information. This sheet is populated by a Google Form that is filled out by bidders at the start of the day, kind of like a registration form.

The second sheet (sheet2) contains sale item details, along with the details of the buyer of each item. When an item is sold, we enter the winning bidder's bidder number, and this populates the previously empty bidder_name, address, phone number etc fields in the same row as the item just sold.

What I need to happen is, once an item has sold, and we have entered the winning bidder's bidder_number next to the sold item (which them fills out the rest of the row with the bidders personal details), I need to be able to generate a receipt containing all the information in that row. So the receipt would look something like:

AUCTION RECEIPT

Bidder ID:

Bidder Name:

Address:

Item Number:

Item Description:

Item Price

This all needs to happen within Google Docs/Drive, as we will have multiple people entering data into this sheet at the one time (it's a large auction, lots of people, lots of items being sold etc)

I have already setup a receipt template within my google drive account to illustrate what I need the receipt to look like, and exactly what data I need to contain. This folder also contains the Google Sheet with all the bidder and sale data. So I will just share this folder with the person who takes on this project, and you should have access to everything you need to get the job done.

I will need this completed within the next 24 hours.

Please don't hesitate to contact me if you require more information.

Many Thanks,

Ben

Habilidades: Excel

Ver mais: needs of a buyer, name and address template excel, google. docs, docs. google, what is google docs, share google docs, google google docs, google excel docs, google docs share, google docs is, google contact information, get a job at google, excel in google docs, excel google docs, docs.google.docs, receipt, google-form, google sheet, google form-2, google drive, google drive c, data in, ben price, entering address excel, access google spreadsheet

Acerca do Empregador:
( 3 comentários ) Sydney, Australia

ID do Projeto: #5105778

Premiar a:

deepbluetech

Hi Ben, I understand the project is urgent and can take on the job. Only thing I would like to know is where would you like the Auction receipt to be placed so that its easier for you to print ? Please confirm a Mais

$100 AUD em 1 dia
(76 Avaliações)
5.4

4 freelancers estão ofertando em média $150 para este trabalho

difan016

Ready to start work and complete work fast with accuracy kindly check my reviews and give me a reply give me more insturction will wait for your reply Regards, Sultan

$250 AUD in 0 dias
(55 Comentários)
4.7
wbslivera

Hello, I am Oracle certified professional java programmer and have Bsc.IT. I can do this in 24 hours it will be a java program but will work as u need. thanks

$105 AUD em 1 dia
(5 Comentários)
3.5
muzammil21

Dear we have a team of 12 people that can handle your [url removed, login to view] have done many projects..we will follow according to your [url removed, login to view] only after the [url removed, login to view] will give you best result with limited [url removed, login to view] Mais

$144 AUD em 1 dia
(4 Comentários)
2.3