S
Scoops
Hello! I have never really used Excel much but I have had an idea
which could make some of the work I do a lot easier. I know Excel is
powerful but I don't know the best way to approach it so can anyone
out there help me?
I make visits to places and record what kind of visit it was on a
spreadsheet with the values in each cell being the date. At the bottom
there is a summary box which shows, on each date, how many visits I
made of each type. At the moment this is done manually but I am sure
it can be done automatically only how?
On a different sheet I would then like to have a summary of all the
visits and so on that have been done, selectable by month would be
nice, or location, or visit type. I could even incorporate graphs and
so on though that isn't too important.
I have been looking at the documentation that comes with Excel but
there are so many different functions that could be used I could do
with someone pointing me in the right direction. Thanks for you
help!!!
which could make some of the work I do a lot easier. I know Excel is
powerful but I don't know the best way to approach it so can anyone
out there help me?
I make visits to places and record what kind of visit it was on a
spreadsheet with the values in each cell being the date. At the bottom
there is a summary box which shows, on each date, how many visits I
made of each type. At the moment this is done manually but I am sure
it can be done automatically only how?
On a different sheet I would then like to have a summary of all the
visits and so on that have been done, selectable by month would be
nice, or location, or visit type. I could even incorporate graphs and
so on though that isn't too important.
I have been looking at the documentation that comes with Excel but
there are so many different functions that could be used I could do
with someone pointing me in the right direction. Thanks for you
help!!!