Em Andamento

Excel Data Manipulation

I am helping out at an Auction this weekend. My main job is to manage bidder registration and item sale information. I have setup an excel spreadsheet for this purpose. The spreadsheet has 2 sheets within.

Sheet 1 is bidder information (first name | surname | phone number | identification details | bidder_id ) the bidder number is determined by the row number.

Sheet 2 is Sale Item details (Item/Lot Number | Description | Final Sale Price | Winning bidder_id | bidder name | phone number | etc)

Once a sale is made, we enter the winning bidder's bidder_id into the 'winning bidder_id' field in the row of the sold item.

This is what I need to happen:

When the bidder_id is entered, the empty fields in that row pertaining to bidder details (name, phone number, address, etc) need to be automatically populated. All the required bidder details exist in Sheet1, and the common factor between the two sheets is the bidder_id (once it has been entered into Sheet2).

I have setup the attached spreadsheet to contain some fake bidder details for you to work with, and all the item details have been entered into sheet 2.

Many thanks in advance. Please don't hesitate to contact me if you require further information. I need this done in the next 24 hours, as the auction is this weekend.

Habilidades: Processamento de Dados, Processamento de dados, Excel

Ver mais: advance excel 2013, excel advance, data entry weekend job, excel data sheet, advance excel, fake data entry, spreadsheet manipulation, number manipulation, contact excel sheet, excel name phone number, excel data information, enter phone excel, data name contact number, data entry fake, name phone number excel, price excel spreadsheet work, excel sheet contact information, excel data description, phone number address excel, excel spreadsheet address contact, excel spreadsheet field, excel manipulation, excel contain, item description spreadsheet, fields excel spreadsheet

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

ID do Projeto: #5102168

Premiar a:

zExcel

Hi, My name is Jon and I can help with this real quick. Let me know if you're ready to start now -----------------------------------------------------------------------------------------

$35 AUD em 1 dia
(10 Avaliações)
3.9

13 freelancers estão ofertando em média $44 para este trabalho

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation. I can implement this in couple of hours....

$40 AUD in 0 dias
(146 Comentários)
6.5
priyal1997

Hi There I'm happy to help you on this JUST TEXT ME.. SO I CAN DO THE JOB FIRST.. THEN YOU CAN CHECK AND OFFER ME THE JOB ONLY IF YOU ARE SATISFIED. I CAN GIVE A MORE PROFESSIONAL LOOK FOR THIS ;-)) I can finish t Mais

$50 AUD in 0 dias
(74 Comentários)
5.8
mrbrave

Expert Excel user with great experience here...You can check my history, I have completed over 100 excel projects on this site...Looking forward to work with you.

$54 AUD em 1 dia
(107 Comentários)
5.7
nazmulcb

Dear Sir, quality and expert researcher here to search a targeted group of people, images, email addresses, database or anything that you are needed you may hire me in full confidence.

$64 AUD em 1 dia
(24 Comentários)
4.8
finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I intend to complete this using VBA in Excel. I have more than 10 years of experience to my credit. Mais

$30 AUD in 0 dias
(26 Comentários)
4.7
FirstChoiceWeb

Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Would love to discuss the details of this pr Mais

$68 AUD in 7 dias
(20 Comentários)
4.4
Virtualworker50

Respected Sir, It would be pleasure for me to render my services to you for creating an automated excel sheet which automatically retrieve the data from sheet 1 based on the bidder ID. I completely understand your r Mais

$35 AUD in 0 dias
(48 Comentários)
4.3
keerthaninfo

Having 10+ Years Experience in relevant works and the work can be completed within 2 to 3 days time, We are ready to start

$147 AUD in 3 dias
(8 Comentários)
3.7
manamika1

Hello, Thank you for the proposal. Professional with over 11 years experience at your service. Excel is my strength. Be assured of sincere and dedicated job completed ASAP. I can finish this in a short time, not late Mais

$55 AUD in 0 dias
(3 Comentários)
1.2
jmvishwas

Hi Sir/Mam, We will deliver the work with in a day with accuracy and TAT. We are team of 10 members, all of them are experienced in BPO. So all of them have etiquette to deliver the work with accuracy and TAT. Mais

$54 AUD em 1 dia
(0 Comentários)
0.0
kaumochan

ALREADY COMPLETED ASSIGNMENT> Shall transfer the file on award, milestone payment. This is simple through index functions in excel. Shall be able to turnaround in quick time. Look forward to hear from you.

$30 AUD in 0 dias
(0 Comentários)
0.0
lequangbmt

Hello. i've read your project and i think it's an easy task.we can start right now if you choose me and you wont disappoint

$30 AUD em 1 dia
(0 Comentários)
0.0
Dvillami

A proposal has not yet been provided

$30 AUD em 1 dia
(0 Comentários)
0.0