LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
terabar
 
Posts: n/a
Default


Wow.. that is cool!! I would presume that Microsoft has automated the
Advance Filter function to produce those Details on a double click
event.

OK, this may sound uncool but my summary is done manually using array
formulae due to multiple conditions
{=SUM((condition1)*(condition2)...)}. Is it possible to produce the
same effect by automating the advance filter and so produce a new
worksheet? I would presume this is using some really complicated
VBA...

Any chance of the source code for this event... if possible??


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=378875

 
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
find and replace links in Excel 2003 MAndrews Excel Worksheet Functions 2 June 3rd 05 06:18 PM
Make excel insert links Robin Excel Discussion (Misc queries) 4 February 24th 05 07:34 PM
How do I remove external links from Excel 2000 workbook? mlwest Excel Discussion (Misc queries) 2 February 4th 05 10:52 PM
How do you set up a data excel sheet that links to a presentation. Moxy247 Excel Worksheet Functions 0 January 31st 05 06:18 PM
How do I Break links Using Excel 2000 DaddyMan Excel Discussion (Misc queries) 1 December 9th 04 10:18 PM


All times are GMT +1. The time now is 06:07 PM.

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"