Find Jobs
Hire Freelancers

Excel formula to populate spreadsheet from other tab

£10-20 GBP

Selesai
Disiarkan 2 bulan yang lalu

£10-20 GBP

Dibayar semasa penghantaran
I'm looking to populate the front sheet of my pricing document using the tabs behind. I need it to look for any populated value, if there is one there, return it. e.g. formula in C25 looks up list in Product List A2:A500 and returns the first value populated. In C26, it should look up the same column of A2:A500 ignore the first value because that's already populated above and return the next value. I cant have it returning row for row as i have limited space. The standard Product should look up Product list tab, Bespoke one should look up the first bespoke tab, Bespoke 2, the second etc. One formula should pretty much work for all, its just what its looking for and how to get it to ignore values that have already been pulled across.
ID Projek: 37864782

Tentang projek

26 cadangan
Projek jarak jauh
Aktif 2 bulan yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hi, Please let me know about the further details of your project ,so that i start the project. I am an Excel Expert with Professional experience working with Excel. I have more than 4 year experience with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a great work for you and ensure your quality.
£10 GBP dalam 1 hari
5.0 (9 ulasan)
3.7
3.7
26 pekerja bebas membida secara purata £20 GBP untuk pekerjaan ini
Avatar Pengguna
Hi there..i am an expert in excel and can make the project for you immediately within few minutes..thanks..looking forward to work with you
£20 GBP dalam 1 hari
5.0 (472 ulasan)
6.9
6.9
Avatar Pengguna
As a seasoned Data Consultant, I have been automating intricate processes in Excel for years, which included complex formula and function creation. Visual Basic is my ally when it comes to such tasks and I'm confident we can create a formula tailored specifically for your pricing document project to efficiently pull the required values and ignore the ones already populated. The objective of my professional journey has always been about maximizing efficiency while minimizing errors. Having encounter-and-conquer'd similar challenges before, I maintain no doubt that I'll find and implement the solution that suits you best with my excelled data analytics skills,
£15 GBP dalam 1 hari
5.0 (57 ulasan)
6.2
6.2
Avatar Pengguna
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
£20 GBP dalam 4 hari
5.0 (37 ulasan)
5.3
5.3
Avatar Pengguna
Hi, please send me your file through chat to help you in this task. I'm an Expert in MS Excel, data entry, Processing and formatting big sets of data. Kind Regards, Moustafa
£10 GBP dalam 1 hari
5.0 (14 ulasan)
4.5
4.5
Avatar Pengguna
UMAIR HERE! I HAVE READ YOUR ISNTRUCTIONS AND I CAN DO IT EFFICIENTLY PLEASE GIVE ME THIS PROJECT I WILL GIVE YOU UNLIMITED REVISIONS EVEN AFTER COMPLETION OF THE WORK. THANK YOU
£15 GBP dalam 1 hari
5.0 (55 ulasan)
4.3
4.3
Avatar Pengguna
Dear Aiden B., https://www.freelancer.com/u/sajidjasi Hope this message finds you well. As a seasoned expert in Microsoft Excel and Google sheets, I bring a comprehensive set of skills and experience. My proficiency includes: Power Query Advanced Formulas and Functions Data Visualization; and VBA Data Analysis Data Validation and Cleaning Pivot Tables and Pivot Charts My dedication to delivering high-quality results, attention to detail, and commitment to meeting deadlines have consistently earned me the trust of clients. I pride myself on my problem-solving abilities and adaptability to various industries and business needs. You can count on me to provide effective solutions and support for your project titled "Excel formula to populate spreadsheet from other tab". I am reviewing the attached file and let we discuss... Regard, Sajid Hussain
£17 GBP dalam 2 hari
4.6 (20 ulasan)
4.5
4.5
Avatar Pengguna
Hello!, I've carefully checked your requirements and really interested in this project Excel formula to populate spreadsheet from other tab. I'm a full time data and statistical analyst. I have worked with many clients from the U.S. and European teams. I'm offering best quality and highest performance at the most fair price. I can complete your project on time and your will experience great satisfaction with me. I have rich experienced in Excel, Visual Basic, Data Processing and Data Entry. For more information about me, please refer to my portfolios. I'm ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thanks
£20 GBP dalam 2 hari
4.7 (3 ulasan)
3.3
3.3
Avatar Pengguna
With over a decade of experience in various aspects of Business Administration and an extensive knowledge of Excel, I am confident in my ability to create the perfect formula for your pricing document. I've successfully completed similar projects in the past, where efficiency and accuracy were paramount, just like in this case. By leveraging on my skills in data processing and analysis, I'll ensure that each cell looks up relevant tabs, disregards values that have already been pulled across, and returns the first populated value. As an individual who thrives on solving complex problems, I perceive your project not as a test of my skills only but also as an opportunity to make a meaningful contribution to your business. My strategic thinking ability will be of immense benefit to create a versatile formula that will work for all the unique product tabs. Moreover, I believe that communication is key when working on such projects. That's why I'm also glad to offer friendly support in case you need any clarifications or adjustments after its completion. By choosing me for this job, you're guaranteed to receive not only quality deliverables but also excellent post-service customer care. Let’s collaborate to turn your spreadsheet into an efficient and sleek pricing document!
£20 GBP dalam 1 hari
5.0 (3 ulasan)
2.0
2.0
Avatar Pengguna
I read your project details, I have 13 years experience on your project. I can do it very easily Already i completed some projects like this. Just a Close your eyes and Trust me. I am sure, you will be happy
£15 GBP dalam 2 hari
5.0 (3 ulasan)
2.0
2.0
Avatar Pengguna
Hi, I'm thrilled to submit my proposal for your Excel project. I believe I got full understanding of your project as far as the description is written. With my expertise in Excel and data analysis, I can certainly assist you in achieving your goals efficiently and accurately. Services Offered:  Excel formula creation and optimization  Pivot table and chart creation  VBA/macros automation  Customized Excel solutions tailored to your specific needs.  Data entry and organization  Data cleaning and manipulation Please click on the CHAT box to unlock the opportunity for us to discuss the project scope, duration, and cost in detail. Thank you for considering my proposal. Best regards, Tayyab Dastgir
£10 GBP dalam 1 hari
5.0 (1 ulasan)
2.0
2.0
Avatar Pengguna
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA
£10 GBP dalam 1 hari
5.0 (5 ulasan)
1.3
1.3
Avatar Pengguna
HI!!!!!!!!!I am excited about the opportunity to streamline your pricing document by automating the population of the front sheet. With my expertise in Excel formulas and data manipulation, I can create a dynamic solution that meets your specific requirements. Using a single formula, I will ensure that populated values are returned from the designated tabs behind the front sheet. By intelligently ignoring values that have already been pulled across, we can maximize space efficiency without sacrificing accuracy. My approach will allow the standard product to pull data from the Product List tab, while bespoke products will retrieve information from their respective tabs, ensuring seamless integration and consistency. I am confident that my solution will not only meet but exceed your expectations, providing a user-friendly and efficient process for managing your pricing document. Let’s collaborate to bring efficiency and clarity to your pricing workflow. Best regards, Muhammad
£20 GBP dalam 1 hari
5.0 (1 ulasan)
1.5
1.5
Avatar Pengguna
As an experienced data entry specialist with a deep understanding of Excel, I am confident that I can tackle your pricing document challenge. My analytical mindset and obsession with detail make me an expert at developing formulas that extract information efficiently and effectively. Specifically, your project demands keen attention to discern populated values and progress without repeating rows, which are skills I have honed over the years. Having implemented numerous data-driven solutions in my career, I am well-versed in creating adaptable formulas that can handle diverse scenarios without compromising on accuracy. Your requirement for one formula to work consistently across all products is exactly the kind of puzzle-solving I genuinely enjoy. And don't worry about me keeping up with bespoke tabs; as a quick learner, adapting to new environments and specific needs is one of my greatest strengths. In choosing me for this job, you're investing in commitment and zeal for excellence. Embarking on this project together will mean not just delivering what you need but also collaborating closely to ensure it exceeds expectations. Let's optimize your pricing document and make it work smarter, not harder!
£15 GBP dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
saya ingin mengambil project ini karena saya mempunyai pengalaman yang banyak dalam bidang ini dan saya berharap bisa segera bergabung dan mengerjakannnya
£15 GBP dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
HI , I propose a dynamic formula that intelligently searches through the specified product lists, ensuring each cell in the front sheet pulls the next available value while avoiding duplication, providing a seamless and efficient solution for your pricing document. waiting...
£15 GBP dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am excited to read your post , and I believe my skills and experience makes me fit for this project. I'm confident I can apply my expertise to help you achieve results. I'm available to start immediately and would love to discuss this project further with you. Please let me know if you have any questions or would like to schedule a call. Thank you for your time and consideration.
£12 GBP dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
As a skilled data entry specialist with a broad range of experience, I am confident in my ability to effectively address your need for visible, accurate data processing across your pricing document. Over the years, I have assisted numerous clients in similar projects, employing concise Excel formulas that locate and return only the unique values they require. Understanding that you require maximum utilization of limited space, I will ensure that my formulas eliminate any potential redundancies. Drawing from a client base spanning different countries, such as the UK and Australia, I have honed my ability to work with diverse datasets effectively. Whether it's the standard list or varying bespoke lists, I am adept at tailoring a single formula to gather the precise information you need while ignoring duplicates or values already populated. Ultimately, my dedication to quality workmanship and knack for meeting deadlines make me the perfect candidate for your project. Your satisfaction is paramount to me - this is why I offer flexibility for revisions to ensure complete alignment with your preferences. Don't hesitate to choose me for an efficient, thorough approach to your data management needs.
£20 GBP dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Greetings I am a digital lead working with big data and large excel sheets. My areas of speciality is in Excel sheets financial modelling and data visualisation in excll and power BI. Consider me for the contact me an i will submit my work. Kind regards
£60 GBP dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am a professional linguist with a Bachelor's degree in English and communications. I believe that I am a perfect fit as I have over four years of writing experience ranging from persuasive, expository narrative; persuasive, and creative contexts. I am also able to work with PDF and Excel.
£10 GBP dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
because I am someone who is able to work under pressure and always try to carry out tasks according to deadlines.
£15 GBP dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera UNITED KINGDOM
Manchester, United Kingdom
5.0
4
Kaedah pembayaran disahkan
Ahli sejak Okt 18, 2018

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.