klsservices
New Member
- Joined
- Jun 4, 2010
- Messages
- 5
Hi
I have a spreadsheet that at present has a sheet where 2 weeks data is pasted onto 2 columns, a calculation is performed in the end column and those results are sorted into largest-smallest & is created into a graph.
All this is done by copying and pasting data into a sheet and sorting the totals
this is ok but open to errors and you are constantly having to cut and paste each week.
what I want to get to is
I have re-created the data into a new sheet which has only the total calculations I need for the whole year,
but now I need to work out how to create a graph for only the weeks data I choose each time.
I am going around in circles so I am hoping someone can help - Thanks in advanced, K
[/IMG]
I have a spreadsheet that at present has a sheet where 2 weeks data is pasted onto 2 columns, a calculation is performed in the end column and those results are sorted into largest-smallest & is created into a graph.
All this is done by copying and pasting data into a sheet and sorting the totals
this is ok but open to errors and you are constantly having to cut and paste each week.
what I want to get to is
- that you have a drop down list of the dates (I have worked how to do this already)
- you select the week you wish to see in the drop down list
- then it goes and finds the same date on the Data sheet and returns that data,
- sorts it High-Low and a graph is populated.
I have re-created the data into a new sheet which has only the total calculations I need for the whole year,
but now I need to work out how to create a graph for only the weeks data I choose each time.
I am going around in circles so I am hoping someone can help - Thanks in advanced, K