Hi,
I have an excel workbook with two sheets.Both sheets have 'item number
as a column.Both sheets contain different number of rows.I want t
write a macro for displaying the common items in both sheets on a pag
(comparing both the sheets and getting the common item numbers)

I have to write a macro for generating the Waterfall char
attached(Waterfall.doc).The 'Actual' values come from one sheet and th
'Forecast' value from the other of the same worksheet.(Item 1,Ite
2......) are the common items in both the sheets.Varianc
=Actual-Forecast.........

Does this actually need a macro or can be done using a simple exce
worksheet ?



Attachment filename: waterfall.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62013
--
Message posted from http://www.ExcelForum.com