Suoritettu

Fill in a Spreadsheet with Data - Create Quotations easily

I want to easily make Quotations/Offers to customers for which I want to use our database as Source Document. In another sheet (Quotation Sheet), which needs to have a very nice layout, I want then to be able to select per row a certain product (SKU) where then automatically the DESCRIPTION and GROSS PRICE needs to be shown.

So basically:

In Sheet 1, there will be around 2000 products/SKU's with descriptions, price, etc... (which is copied from our Magento database).

Then in Sheet 2 of the same XLS file, I want to make it possible to easily key in a certain SKU.

When selecting a SKU, then automatically the Description and Price (amongst others) should be shown which should come from the database details from Sheet 1.

Taidot: tiedonsyöttö, Excel, Excel VBA

Näytä lisää: fill spreadsheet with data, copy typing, Fill-Spreadsheet-with-Contact-Data/, https www freelancer com projects data entry fill spreadsheet with data 10799431, excel single quote in string, how to add single quotes in excel, excel add single quotes around text, how to add single quote and comma after each record in excel, how to add double quotes in excel column, how to add single quotes in excel concatenate, excel add quotes to csv, excel single quote char, data entry, excel, https://wwwfreelancercom/projects/data-entry/fill-spreadsheet-data-entry/, fill spreadsheet with data, data-entry/fill-spreadsheet-with-data-entry, fill spreadsheet data repost, data entry business cards details spreadsheet, fill excel spreadsheet data, fill spreadsheet data

Tietoa työnantajasta:
( 18 arvostelua ) Gronau, Germany

Projektin tunnus: #15118019

Myönnetty käyttäjälle:

TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy Relevant Skills and Experience ex Lisää

€20 EUR 1 päivässä
(203 Arvostelua)
6.2

22 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

pandey2008

Hello Sir, we have 8 member team and we can start work right now just give us one chance we will do our best,awaiting ur answer.

€29 EUR 1 päivässä
(410 arvostelua)
7.1
muzammil21

A proposal has not yet been provided

€34 EUR 1 päivässä
(74 arvostelua)
6.4
rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. Will send sample of my work, if requested. Rgds Rohit Pithisaria Relevant Skills and E Lisää

€30 EUR 1 päivässä
(82 arvostelua)
6.1
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you Relevant Skills and Experience I have 7 years experience. Proposed Milestones €19 EUR - Milestone

€19 EUR 1 päivässä
(30 arvostelua)
5.8
sujonmax2

Old account has been closed new account start work. Stay tuned, I'm still working on this proposal.

€23 EUR 1 päivässä
(84 arvostelua)
5.6
vlayausa

Hello, I fully understand your project and I would love to help you with it. Please contact me for more information. Relevant Skills and Experience I have a lot of experience with VBA Excel. You can check my profile Lisää

€30 EUR 1 päivässä
(115 arvostelua)
5.7
Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work Relevant Skills and Experience Data Entry, Excel, Excel VBA Proposed Milestones €23 EUR - Lisää

€23 EUR 1 päivässä
(63 arvostelua)
5.4
Nitu1988

Hello sir, I am interested the data entry job you posted. I have experience almost all kind of data entry work. So data entry is quite easy for me to do. Relevant Skills and Experience I do all of my work with great s Lisää

€29 EUR 1 päivässä
(70 arvostelua)
5.4
€23 EUR 1 päivässä
(101 arvostelua)
5.5
cjie

Hi there - My name is Collins. I’ve read your project description and I can see that you’d like to hire someone for data entry. I have 3 years’ experience in data entry and web research. Relevant Skills and Experience Lisää

€30 EUR 1 päivässä
(11 arvostelua)
4.1
humayoonsheikh4u

Dear Sir I am an Excel professional having hands on expertise in developing invoice generating spreadsheet I will do your project as per your requirements by applying advanced excel formulas. Relevant Skills and Exper Lisää

€34 EUR 1 päivässä
(8 arvostelua)
3.9
€23 EUR 1 päivässä
(2 arvostelua)
3.8
aubrey03

My bid is to implement what you want in your workbook. I am an Excel Expert and I already know what to do, I only need to create an array formula in your invoice sheet. Relevant Skills and Experience You may check som Lisää

€30 EUR 1 päivässä
(6 arvostelua)
3.0
shakerhany

Please read, I've completed a very similar project recently, and I am ready to provide you with a demo before you award me the project, so you can make sure I understood the requirements. Relevant Skills and Experienc Lisää

€30 EUR 1 päivässä
(13 arvostelua)
3.0
aditya357

I have a strong background of theoretical statistics and probability theory.I graduated from Indian Institute of Technology, Kharagpur in 2016. I am currently enrolled in integrated PhD in mathematics. I have experien Lisää

€24 EUR 3 päivässä
(2 arvostelua)
2.6
AhmedHassan1122

Excel VBA expert

€24 EUR 1 päivässä
(1 arvostelu)
2.5
chintuag

I have read the project description and available to work on it immediately Relevant Skills and Experience I have recently closed 4 projects in Excel using VBA/Macros. Proposed Milestones €21 EUR - Automate Excel She Lisää

€21 EUR 1 päivässä
(1 arvostelu)
2.5
mpunn2007

pls pm me if u require this project to be done within a day. I have mastery in such type of projects.

€29 EUR 1 päivässä
(3 arvostelua)
1.5
vw6417773vw

Hello I'm experienced freelancer who worked with a team in the past. I do excel automation almost on a daily basis and I can guarantee you will be provided with a quality results. Best regards Relevant Skills and Ex Lisää

€34 EUR 1 päivässä
(1 arvostelu)
1.1
€14 EUR 1 päivässä
(1 arvostelu)
0.9