Urgent Macro help needed !

[sameer27p]

I need to generate the waterfall model which is specified in the exce
sheet attached.I am done with some part of it,but I am not sure how t
plug in the exact values from the two sheets and generate th
model.........
It would be kind if you'll can have a look at it and give me som
suggestions.I need to write a macro for this.Is there some ready macr
available ?????

Waterfall1.xls is attached !

Reply awaited.....Thanks for your time and consideration..Have a nic
day ahead

Attachment filename: waterfall1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62151

 

[Bob Flanagan]

Sameer, checkout http://www.add-ins.com/waterfall_charts.htm

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[sameer27p]

that's a graphical tool...i want to display data in the form of figure
for various item