Create a formula between 2 excel sheets


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?

Навыки: Excel, Excel Macros

Показать больше: create formula excel, create formula excel interest, create standalone excel sheets, link excel sheets automatically updates, excel create formula will subtract total stock cell, how to create a formula in excel for multiple cells, how to create a custom formula in excel, how to create a formula in excel 2016, how to create a formula in excel, how to create hyperlink in excel between sheets, how to create hyperlink in excel using formula, how to create multiple excel sheets from one excel sheet, automatically create org chart excel, compare 2 excel sheets, how to apply a formula to multiple sheets in excel, how to create formula in excel, how to create a complex formula in excel that calculates a 30 decrease, create an excel chart that automatically updates with new data, how to create a dashboard in excel that updates automatically, how to merge data of 2 excel sheets

О работодателе:
( 1 отзыв ) Perth, Australia

ID проекта: #28351234



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.

$20 AUD за 1 день
(1 отзыв)

15 фрилансеров(-а) готовы выполнить эту работу в среднем за $20


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.

$30 AUD за 1 день
(135 отзывов(-а))

Hi, I am well versed with Excel formulas and can help on this. Looking forward to your response. Thanks

$30 AUD за 1 день
(65 отзывов(-а))

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day

$25 AUD за 1 день
(64 отзывов(-а))

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 Больше

$25 AUD за 1 день
(33 отзывов(-а))

ur want connect two sheet get info

$35 AUD за 1 день
(15 отзывов(-а))

Hello I have a vast experience of excel and excel macro. You can check in my profile my previous work . Waiting for positive response.

$10 AUD за 1 день
(6 отзывов(-а))

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 Больше

$15 AUD за 1 день
(1 отзыв)

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 Больше

$20 AUD за 1 день
(1 отзыв)

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 Больше

$15 AUD за 7 дней(-я)
(0 отзывов(-а))

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call me a "Prince of Excel". I promise I will Больше

$10 AUD за 1 день
(0 отзывов(-а))

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.

$20 AUD за 2 дней(-я)
(0 отзывов(-а))

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.

$15 AUD за 1 день
(0 отзывов(-а))

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 Больше

$20 AUD за 2 дней(-я)
(0 отзывов(-а))

I feel that your vacancy ideally fits my work experience, skills and qualifications. Therefore I will be able to make a significant contribution to your business as well as fulfill my potential. I don’t believe in word Больше

$10 AUD за 2 дней(-я)
(0 отзывов(-а))