Create Search Box for Excel

£20-250 GBP

Imekamilika

Imechapishwa

over 2 years ago

£20-250 GBP

Kulipwa wakati wa kufikishwa

I want to have a search box where I type in a customer name and it pulls information from the main data sheet containing data. eg Type SMITH into search box, I get results for where the customer item is stored. [login to view URL] I want to have a new sheet for the Search Bar. I want to pull date from ORDER SHEET 2022 . Search bar input would be customer name or surname. The results pulled would be LOCATION (J), TOTAL (X), Completed (AB), Deposit (AD). If possible also (not sure if this) - I would then like to be able to then be able to fill something on the search bar so it would fill in cell AC back in the ORDER SHEET 2022 page. So if a customer comes to collect their product. We can search for their name on the new tab, this will give back any results. If the customer takes their product we can mark it as COLLECTED (with a date) and this would then fill out column AB in ORDER SHEET 2022 with that information. I'm not sure if this is possible though

Excel

Data Processing

Kitambulisho cha mradi: 32662134

Kuhusu mradi

43 mapendekezo

Mradi wa mbali

Inatumika 2 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@rahul62544

£0 GBP ndani ya siku 1

5.0

(321 hakiki)

7.1

43 wafanyakazi huru wana zabuni kwa wastani £97 GBP kwa kazi hii

@bouslimi1979

Hello, I can code a macro for the Search box. And it will pull the data from the ORDER SHEET. Also it's possible to update that sheet with new data entred in the Search Tab. I just need a short discussion to clarify 2 points. Thanks

£80 GBP ndani ya siku 1

4.9

(321 hakiki)

7.9

@AccountantArman

"Sir, I am Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 115+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "

£66 GBP ndani ya siku 1

4.9

(137 hakiki)

6.3

@kayemhussain

Dear hiring manager,, Fully understand your requirements & already i saw your attached google sheet, I can provide you customer name or surname. The results pulled would be LOCATION (J), TOTAL (X), Completed (AB), Deposit (AD). .understood what you require. I can do this project with 100% accuracy right now. I want to send you sample tamlate because your satisfaction is my pride. I am the best freelancer for your job. Choose me and I will deliver within right time. I can get this done for you. Thank you M A Kayem Hussain

£40 GBP ndani ya siku 2

5.0

(74 hakiki)

6.1

@suvashdev475

Greetings, I think you are looking for someone for your project who expert in to type in a customer name and it pulls information from the main data sheet containing data. we can discuss more about the work? First of all, I'll provide you a demo file of the work. So, please discuss more over the chat. I am waiting for your kind response. Thank you

£20 GBP ndani ya siku 2

5.0

(52 hakiki)

5.6

@rayyankabir

Hello, I am the expert on SQL server, Excel, Microsoft Access and also in Power BI. I am also very skilled freelancer who completes his job with 100% client satisfaction. I have also profound knowledge in other sectors that are related to that field. For these amazing skills, I have the ability to bring 100% success in every project. Thank you

£200 GBP ndani ya siku 7

5.0

(17 hakiki)

4.8

@monicawriter99

Dear employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Create Search Box for Excel ". I have more than 3 years of professional experience in statistical analysis. Besides, I have skills in Data Processing and Excel. On Freelancer.com, I seek to help individuals, groups, or companies solve their statistical problems in various types of disciplines. My previous experience includes, but is not limited to: Descriptive Statistics, Visual Representation, Regression Analysis, Analysis of Variance, Nonparametric Statistics, etc. Click on my profile, (https://www.freelancer.com/hireme/monicawriter99) to see my profile reviews as well as have an insight into what I will do for you. Thanks & regards.

£160 GBP ndani ya siku 3

4.6

(13 hakiki)

4.6

@ACCASpogmai

"Hello Sir, I am an advance level EXCEL EXPERT and all Excel related work. This task is very easy ,I will complete this task with 100 % Accuracy. I have completed similar projects with five stars from client. About me I am Chartered Accountant with more than 4 years of experience from worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expects 100% accuracy from me. I am Microsoft Excel, accounting, auditing, Form Creation in Excel through VBA and in Google Sheet and QuickBooks expert. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. Regards Spogmai Kakar "

£55 GBP ndani ya siku 1

5.0

(19 hakiki)

3.8

@varimaxanalytic

Hello, I am professional freelancer with a Master's degree in Data analytics making me a suitable person for your project. I have more than 8 years of professional experience in Data analysis. Besides, I have skills in Data Processing and Excel. For your reference, you can check reviews\ portifolio for all the projects I handled so far. Hope to connect with you on personal chat. Regards, Peter

£122 GBP ndani ya siku 2

5.0

(3 hakiki)

3.6

@konanhenry1111

"I am ready to start now. I have read the deatails that u attched on the project I am certified at data entry exam on freelancer. Let us discuss in chat. "

£30 GBP ndani ya siku 7

5.0

(11 hakiki)

3.2

@arslanu2

Hi! We are proficient in MS Excel, Google sheets, spreadsheets accounting, and its use in business and analysis. We can enter, arrange, analyze, as well as present your data with accuracy. Please contact back for completion of your work in time and within budget. Regards McKenzie Business Solutions Lahore, Pakistan

£250 GBP ndani ya siku 7

5.0

(2 hakiki)

3.3

@surya2chandra

I have good experience in google sheets formulas and appscript. I can complete both the tasks, filtering the data by search bar name and input data back again into main sheet from searchbar sheet. Thanks.

£30 GBP ndani ya siku 2

5.0

(9 hakiki)

3.2

@fahimkay

Hello there, I am interested to work with you on this project. I have good working experience of google sheets. Please discuss in chat and start working right now. Thank you!

£30 GBP ndani ya siku 1

5.0

(2 hakiki)

2.5

@andylawsonstatz

Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel userform and VBA. All clients call me "Prince of Excel". I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Best regard!

£120 GBP ndani ya siku 3

5.0

(3 hakiki)

1.7

@khanmaiprogram

Hi Thanks for your job posting! I am a Desktop App Developer and your project is very interesting for me. I am an expert in ✔️C / C++ / C# / Java / JavaFx / Python/QT ✔️VBA / VB / .NET /EXCEL /ACCESS / SQL Database. One of my top skill is VBA. I worked on numerous similar projects in the past and always impressed the clients with my excellent solutions. But I have couple of questionsin the requirements, please ping me on chat to discuss more on that. I sincerely hope this project would be first step in long term relationship with you. Please give me your detail… Best Regards.

£100 GBP ndani ya siku 7

5.0

(1 hakiki)

1.6

@soccon107

Hi, I have read your instructions as well as the attached file, I have a very good ability to work with google sheet and excel. I can get things done very quickly, carefully and conscientiously, so work with me for the best and fastest results. We can discuss more about work and prices via chat

£80 GBP ndani ya siku 1

4.7

(3 hakiki)

0.7

@rahulgemsny

Hi there, I am rahul. I am an expert in excel, word,& PowerPoint and all kinds of work in excel. I have 7 years work experience in this. I ensure you i can do your task on time with full accuracy. I'd be very happy to discuss this further. I hope you will consider me. Thankyou!

£135 GBP ndani ya siku 2

5.0

(1 hakiki)

0.0

@timurkhan15701

Dear Sir/Madam, I have expertise in word, excel, data entry, copy and pasting. I will exactly type the pdf file to word as you want. Inbox me for further details. Awaiting for you positive response. Regards Timur khan

£75 GBP ndani ya siku 7

0.0

(0 hakiki)

0.0

@AndreiSokolov

===== I CAN CREATE SEARCH BOX FOR EXCEL PERFECTLY ===== Dear Client! I am Andrei, experienced programmer from Russia. I have read your requirement and I noticed that I am appropriate to this project. As a skillful software developer, I have rich experience with Excel and ExcelVBA,Macro and built many projects like this. I promise I will finish this project with high quality on time. I hope you to contact me so that we have a full discuss with the project. Best regard!

£135 GBP ndani ya siku 2