Rolling 12months and creating a graph from data

AsherD2

New Member
Joined
Jun 21, 2015
Messages
1
Hi

I have an excel workbook and want to have on one sheet with the results of reports that I get on a monthly and want to keep track that I do receive them and create a graph from the data.
I have have on the second sheet the results of the data that I need to formulate and the formula I have been working with.

What is the best way to automate my monthly data calculations to automatically move over once a new
months data is entered? Currently, I will just manually pull the formulas over.

 
Last edited:

mick0005

Active Member
Joined
Feb 21, 2011
Messages
406
Your images are not visible. Please see the link in my signature to learn how to properly post examples of your work using the HTML Maker. You need to show us what you have now, and what you're expecting as a result.

Also, may I suggest you use some bullets to describe what your problem and requirements are? The sentence above is not clear... I don't know what you mean when you say "I have have on the second sheet the results of the data that I need to formulate and the formula I have been working with. " Maybe this is because I can't see your images. I'm not sure.
 

Forum statistics

Threads
1,082,587
Messages
5,366,486
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top