Results 1 to 2 of 2

Thread: Macro Programming in VB Editor of Excel

Threaded View

  1. Jul 14th, 2004, 09:35 AM #1
    sameer27p
    sameer27p is offline

    Thread Starter
    New Member
    Join Date
    Jul 2004
    Location
    Alabama
    Posts
    10

    Macro Programming in VB Editor of Excel

    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)...
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width