Macro Programming in VB Editor of Excel

[sameer27p]

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 to write a macro for displaying the common items in both sheets on a page (comparing both the sheets and getting the common item numbers)


I have to write a macro for generating a Waterfall chart.Have attached a Waterfall.zip file showing the format and requirement.

The 'Actual' values come from one sheet and the 'Forecast' value from the other of the same worksheet.(Item 1,Item 2......) are the common items in both the sheets.Variance =Actual-Forecast.........

It would be kind of you if someone could help me generate this waterfall model using Macro programming in Excel (VB Editor)...

[Ecniv]

From the sounds of it this is coursework.

Which means you should be doing it so you understand how to get it working the way you need it.

You need to look up the following information and experiment a lil:
- excel function vlookup
- Tools>Macros>Record macro - this records your actions so you can see how the code would be made up. Use it assist in making a start on the code you need.
- use 'if' statements for comparisons
- debug.print and breakpoints - useful for stepping through a running vba code sub/function and finding out what is happening.

When you have code and it doesnt' work right, check help files and online first for the answers, then post your code in here with the error message.


Vince