Forum Discussion
Excel Formula for adding one cell on one worksheet to another cell on a separate worksheet
I'm looking for a formula that will allow me to take data from one cell on one worksheet (tab) and add it to a cell on another worksheet (tab). Basically, I have one worksheet (tab) entitled "Month" and another worksheet (tab) called "Year to Date" (YTD). The monthly tab is current data and the YTD tab is a running total for the year. How can I add the monthly data to the YTD worksheet?
5 Replies
Hi Tom,
As variant you may use VLOOKUP or INDEX/MATCH linking data for the same dates.
Sergei,
Please expand your answer. I am a novice with Excel. Could you please provide step by step instructions? Thanks! Greatly appreciated!!
Tom,
If you provide small sample file of how is your data structured and what you'd like to receive it'll be easier to provide step by step instructions
