Mapping some TB codes in excel and using what if functions to pick required data
- or -
Post a project like this2313
£60(approx. $75)
- Posted:
- Proposals: 15
- Remote
- #1824659
- Awarded
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
Islamabad
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
Greater Noida
11141283549598984328852745411750797108221512246901228050139401514064161768403
Description
Experience Level: Expert
General information for the business: n/a
Industry: Business
Description of excel work: I have an excel document (balance sheet and income statement) that is linked to various places .
I want to create a new tab which will use whatif function based on a code (TB account number) and pull all the information it needs from one source( a tab in the work sheet) rather than various other sources.
So the output will be a tab which will be driven by whatif formulas to pick up all the data it needs from a separate tab which will be mapped to the TB (Account codes)
This job will not entail creating something from scratch. However there are a large number of links
Extra notes:
Industry: Business
Description of excel work: I have an excel document (balance sheet and income statement) that is linked to various places .
I want to create a new tab which will use whatif function based on a code (TB account number) and pull all the information it needs from one source( a tab in the work sheet) rather than various other sources.
So the output will be a tab which will be driven by whatif formulas to pick up all the data it needs from a separate tab which will be mapped to the TB (Account codes)
This job will not entail creating something from scratch. However there are a large number of links
Extra notes:
Gideon N.
98% (20)Projects Completed
16
Freelancers worked with
14
Projects awarded
13%
Last project
23 Feb 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you please share the sheet to get an idea of what to pick from where? Or just clarify that the data to pick is from other tabs within that excel sheet? You talked about links, does it mean to get some data using link from online sites?
557998
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies