Hi there,
I have a workbook which extracts data and splits it by day into chronological order with a corresponding result (e.g. time and blood pressure). Currently I have a worksheet produced by a macro that looks like the picture attached for 12 days. Days 1-12 take up 2 rows each throughout the rest of the worksheet: Columns A-X
Can anybody please help me to generate a macro which would allow the user to simply select which day they would like and the macro produce one line graph for that day on a new worksheet "Results". This data is a full 24-h recording over 12 days providing 15-min averages. Some times values are missing or the monitor was not worn for the full 24-h so the xlup function would be needed here for the ranges.
In short, the desired outcome is:
A simple options box/tick box on the "Results" worksheet that would go into the "GraphData" worksheet and select cells with values in to produce a line graph showing changes in blood pressure over that particular day.
I hope this all makes sense and thank you for any help you can offer!
Telemanes
Bookmarks