Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Totalling data from several workbooks to a Summary Sheet | Excel Worksheet Functions | |||
Totalling data used in drop down boxes? | Excel Discussion (Misc queries) | |||
Transfering and totalling corresponding data to other worksheets | Excel Discussion (Misc queries) | |||
Totalling across sheets | Excel Programming | |||
Totalling across sheets | Excel Programming |