[BAttached you will find the capacity model. I created a “Home” sheet to store some data to be use in the future. “Time Data” is now getting the information from the “ARS Data” and using the data from the “Home” sheet to create the averages.
Now, we should be able to create the graphics based on “Time Data”. Also, we have to find a way to populate “Aux” column A and B automatically from the “ARS Data” and drag the formulas in C and D.
Can you please help me with this problem?
Thanks
You will need to change your thread title to something that actually describes your problem, please.
And while you are at doing that, please include more detail about what you are trying to do. Show the data you are working with (you did that) and show examples of your output and how you arrived at that?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You will need to change your thread title to something that actually describes your problem, please.
And while you are at doing that, please include more detail about what you are trying to do. Show the data you are working with (you did that) and show examples of your output and how you arrived at that?
I am trying to populate “Aux” column A and B automatically from the “ARS Data” and drag the formulas in C and D. I am not sure how to do this can you please help?
The purpose of this problem is to graph the data and see maximum amount of guests that are in the room so that way I know to increase the size of the room. That is what my data shows.
expanding further. .
The user will paste the data he/she wants to analyze in the “ARS Data” sheet. However, the “Aux” sheet will have to be populate automatically from it in order to generate the whole analysis.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks