Find Jobs
Hire Freelancers

EXCEL: pass one cell's data as an argument in another cell's forumla

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
Hi! I have a cell, A1, which contains a string representing a tab name "tab2" (as in, the name of a tab within the worksheet). Would like to pass that cell's data as an argument in another cell's formula, so cell b1 = a1!c1 ie, I use the data in A1 to identify the content of tab2c1. The goal is that I can pull whatever name from a1 or a2 or a3 into b1 or b2 or b3s formula to pull that c1 cell from the specified tab.
Project ID: 17934970

About the project

20 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am proficient with excel macro/VBA development, I can write the macro to pass cell value as argument as specified, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project
$50 USD in 1 day
5.0 (113 reviews)
6.4
6.4
20 freelancers are bidding on average $111 USD for this job
User Avatar
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
$50 USD in 0 day
5.0 (779 reviews)
8.6
8.6
User Avatar
Hi, I am good at Excel and VBA. I have reviewed the attachments. Please share the sample file. It would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired time frame. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. Regards, Chandra
$30 USD in 0 day
5.0 (941 reviews)
8.1
8.1
User Avatar
Dear Employer, I will do your excel job, I understood how you want to pass the name. Please message me. Thanks and Regards, Ash
$166 USD in 3 days
5.0 (201 reviews)
7.8
7.8
User Avatar
Hi, I am a financial expert and a guru in Excel/VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner."
$250 USD in 3 days
4.9 (90 reviews)
7.1
7.1
User Avatar
Hi, please send the file, I'll do it right now. No awarding needed at this time, I'll do it, I show it to you then you can award Thanks, Felice
$30 USD in 3 days
5.0 (14 reviews)
6.4
6.4
User Avatar
Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$55 USD in 3 days
4.9 (176 reviews)
6.5
6.5
User Avatar
Hello. I have good skills in Excel/VBA. I'm interest to your project. Contact me please. Thanks.....
$140 USD in 1 day
4.8 (99 reviews)
5.9
5.9
User Avatar
Hi.. I am expert in excel . if you want i can provide you sample work before project. start. please provide more details to do accurate work. thaks Saidul
$35 USD in 3 days
5.0 (46 reviews)
5.8
5.8
User Avatar
Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
$166 USD in 5 days
4.9 (5 reviews)
3.7
3.7
User Avatar
Dear Sir / Madam, As an advanced excel user with valuable Financial / Analytical and Data Entry experience, I would be grateful if you would review my profile for the position advertised. Having worked at high levels within Finance, delivering accurate and timely reports to meet key deadlines has always been an essential part of the quality service I can offer. Also have vast experience in developing financial models via Excel (both basic and advanced). Fee is negotiable based on time. Difficult to assess without visibility of the data
$155 USD in 3 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Hire me I will done your work quickly and perfectly .If you interested please inform. I have a very good knowledge about this work,,
$222 USD in 3 days
5.0 (1 review)
1.4
1.4
User Avatar
I have gone through your description and got pretty much idea of what you want. i assure you that I can do it for you as per your timeline. The skill and resources needed for this project are in my genes. I can immediately start working on your project once you allow me I have a wide skill set but I take just one project at a time. I'm very responsible and committed to what I do. List of skill I have: +Transcriptions +English To Spanish +Mathematics +Video Subtitling +Email Verification +Data Entry +PDF to Excel +PDF to Word +Data Scraping +Data mining Microsoft Word, Microsoft Excel Formula with csv format, Microsoft Access, Microsoft Power Point, Internet Research, Google Docs, Google Spreadsheet, PDF Conversion i .have good experience in data extracted and put into graphs/charts/tables to represent the data
$155 USD in 3 days
5.0 (2 reviews)
0.5
0.5
User Avatar
Dear Hiring Manager I hope you are in good health. With reference to your proposal Excel you mentioned above, I am interested to carry out the this assignment. I have 7 years of professional experience in Accounting. As an analytical and dynamic individual i have a proven history of exceeding expectations through performance, i believe i would be able to participate and impact considerably the ongoing operational success of your company. Some of the key talents i can bring, includes Accounting, Financial Analysis, International Financial Reporting Standards, financial statements preparation, cash flow forecasting, financial statement analysis, budgeting, investment appraisal, and financial reporting. Working with KPMG (Islamabad) as a senior accountant/auditor has given me immense experience in preparation of financial statements in accordance with International Financial Reporting Standards, drafting financial policies, financial statements preparation and analysis of various multinational companies globally. I can combine my effective interpersonal skills with functional knowledge to identify opportunities and deliver a satisfactory outcome while working alone or as a part of a larger team. Your prompt response will be highly appreciated. Sincerely Adnan Baig
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Accounting Professional with more than 9 years experience in bookkeeping, and Accounts. I have in-dept professional experience and have the ability to provide quality services in the following areas with 100% accuracy. * Accounting/Bookkeeping ) * Company setup in accounting software * MS Excel (proficient) * Financial Modeling * Budgeting and Forecasting * Accounts Receivables Management Apart from these I have expertise in the following areas: * Data Entry * Web Scraping and Research * Data Conversion (PDF to Excel, JPEG, XML etc) * Virtual Assistant * Oracle Implementation (SQL, JAVA, Patching, Database Admin etc)
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, i tend to work with a huge number of financial data as salry disbursment, remittance and deposit. For that work experiences i think i can serve your purpose prrfectly.
$150 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
new york, United States
5.0
1
Payment method verified
Member since Apr 2, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.