Totalling data from different sheets.
 

Hi
I have a spreadsheet on my website, here -
http://www.takingthelongwayhome.co.u...%20Reviews.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

Totalling data from different sheets.
 

A macro to do this is kind of complicated. Your data wasn't entered in
a format that I could of done this with a simple macro and since the
task wouldn't be performed frequently I did it manually. It was easier
to fix your worksheets to make a new column for each country and then
put the dates into each row. Once I did this I made a new worksheet
called summary and used Subtotals to get the summary information. See
the attchment at THECODECAGE posting. You can know sort the data as
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 of
taken a couple of hours.


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

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194824

http://www.thecodecage.com/forumz