Totalling data from different sheets.

K

kevhatch

Hi
I have a spreadsheet on my website, here -
http://www.takingthelongwayhome.co.uk/Costing & Reviews.zip
What I would like to do is add another page (Totals) to work out average
costs etc.
by pulling data from all sheets e.g. petrol or accomodation and adding it to
the Totals sheet under seperate headings. There will be extra sheets added as
we progress on the trip.
Hope this makes sense.
Many thanks
Kev
 
J

joel

A macro to do this is kind of complicated. Your data wasn't entered i
a format that I could of done this with a simple macro and since th
task wouldn't be performed frequently I did it manually. It was easie
to fix your worksheets to make a new column for each country and the
put the dates into each row. Once I did this I made a new workshee
called summary and used Subtotals to get the summary information. Se
the attchment at THECODECAGE posting. You can know sort the data a
required and do any type subtotal you need manually.

http://tinyurl.com/y8awn23


It is sometimes better to do things manually rather than with a macro.
I modified the workbook in less than 5 minutes while a macro would o
taken a couple of hours.


+-------------------------------------------------------------------+
|Filename: Costing & Reviews.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=537|
+-------------------------------------------------------------------+
 
Top