+ Reply to Thread
Results 1 to 2 of 2

Referencing cells from another worksheet using VBA

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    8

    Referencing cells from another worksheet using VBA

    Hi All,

    I have an excel sheet where I am planning to summarize the forecasting results for next 6 months.

    For example, I have a forecast sheet where I have forecasted for next 6 months. Like
    for Jan, my forecast data is from D11 to I11.
    And for feb it is from E12 to J12
    And for March it is from F13 to K13 and so on

    In the summary sheet, I have listed all 12 months in diff columns. I am planning to have 12 buttons based on the months they forecast. Once the click the button the corresponding 6 cells (in the same row) should be referenced in the summary sheet. Is it possible to code efficiently, rather than referencing them directly for each diff cells.

    Thank you.

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Referencing cells from another worksheet using VBA

    he corresponding 6 cells (in the same row) should be referenced in the summary sheet
    the two sheets are also not known. however see the sample workbook. download it from

    http://www.speedyshare.com/files/23884771/raknhas.xls

    in this workbook
    righ click sheet "summary" tab and click view code.
    you will see the event code

    now go to summary sheet and select one of the months e.g. Feb what you get in that column

    is this what you want.

    the event code is

    Please Login or Register  to view this content.
    Last edited by venkat1926; 08-20-2010 at 08:13 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1