Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
honyacker
 
Posts: n/a
Default Sum same cell in many books

I want to create a new workbook that sums the cell H22 in every book that is
in a certain folder.
Is there a way to do this? This folder will have a new book added every day
..
Thanks,
joe


  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Sum same cell in many books

Hi honyacker

You can create a Sum workbook with code.
See
http://www.rondebruin.nl/summary2.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"honyacker" wrote in message ...
I want to create a new workbook that sums the cell H22 in every book that is in a certain folder.
Is there a way to do this? This folder will have a new book added every day .
Thanks,
joe



  #3   Report Post  
Posted to microsoft.public.excel.misc
honyacker
 
Posts: n/a
Default Sum same cell in many books

Thanks Ron,
Looks like exactly what I am looking for.

joe

"honyacker" wrote in message
...
I want to create a new workbook that sums the cell H22 in every book that
is in a certain folder.
Is there a way to do this? This folder will have a new book added every
day .
Thanks,
joe



  #4   Report Post  
Posted to microsoft.public.excel.misc
honyacker
 
Posts: n/a
Default Sum same cell in many books

Thanks Ron,
I'll give it a try.

joe

"honyacker" wrote in message
...
I want to create a new workbook that sums the cell H22 in every book that
is in a certain folder.
Is there a way to do this? This folder will have a new book added every
day .
Thanks,
joe



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 23rd 05 11:04 PM
how to copy the same cell across different work books into another workbook easily? sageerai Excel Discussion (Misc queries) 2 November 11th 05 09:46 PM
Function syntax to compare cell contents ES Excel Worksheet Functions 2 May 18th 05 03:53 PM
Syntax for inferred cell references donesquire Excel Worksheet Functions 4 April 4th 05 09:29 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"