Create a formula between 2 excel sheets
$10-30 AUD
Paid on delivery
Hello,
I am looking for someone to write excel formula that auto fills one worksheet with data entered into another worksheet.
I used to have this on an old computer which has got lost track of.
The first worksheet has a budget with number-coded line items, with a manually inputted ‘budget amount’ columns, next to it is an empty ‘actual amount’.
The second worksheet is a simple income and expense record where I will enter:
- the appropriate number-code
- expense / income item description
- dollar amount
When doing so I would like the dollar amount I have manually entered on Sheet 2, to automatically appear in Sheet 1's 'Actual' column according to the number code I have written next to it.
Can someone quote inserting the formula onto the spreadsheets please?
Project ID: #28351234
About the project
Awarded to:
I will insert a lookup formula between the sheets to populate the "Actual" column automatically as and when you enter data on the 2nd sheet.
14 freelancers are bidding on average $21 for this job
Hi there, I can create some custom formula for you so that you can get what you have mentioned in the project description. can we talk? :) Thanks Much, RK.
Hi, I am well versed with Excel formulas and can help on this. Looking forward to your response. Thanks
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day
Dear Sir/Madam, I am EXCEL expert. I am ACCA (Chartered Accountant). I am expert in EXCEL, QB, XERO and WAVE. You can see my profile. I do have the ability to complete the assigned task within an agreed perio More
Hello I have a vast experience of excel and excel macro. You can check in my profile my previous work . Waiting for positive response.
Hi there, I read your project requirement and I am absolutely sure that I can do the project very well. I have worked on similar projects to what you are looking for , and I am confident that I can exceed your expecta More
I have review the attached excel file its a very simple task to do. I have been using excel for automation for more than five years. I can upload a sample solution for you. just send a buzz on direct chat. Formulas Ad More
Hi This is Sourav I have more than five years work experience as a data entry operator as well as admin operation. If I will get a chance to complete the project then it will be purely error free and in timely span. Pl More
I am good for Microsoft excel, this work I will good manage to handle this. If you give me the project I will try to give my best performance.
Hello dear, I read your project description carefully then I think I am the right person which you are looking for. If you want we can discuss more on text. Please text me I will waiting for your response.
Hi, I am the best candidate for this work because I am a great economy student and I have skills in using excel. I also am concetrated and dedicated in what I do so the work will be finnished properly and fastly. Tha More