+ Reply to Thread
Results 1 to 2 of 2

Macro for iteratively updating a grid based on inputs

  1. #1
    Registered User
    Join Date
    04-21-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Macro for iteratively updating a grid based on inputs

    This is a bit tricky for me.

    I have a Workbook called "Workbook1" in which Sheet 1 looks like as shown below. I have a a grid between dates and some alphabets as shown below

    Workbook1-Sheet 1

    image1.PNG

    Now I have another workbook called "Workbook2" in which sheet 1 will have input as shown below. C1 will have present dates and column A will have alphabets.

    image2.PNG

    Now based on value in column A and date in C1 i want a macro button on pressing which we can iteratively add values in the gird in "Workbook2"



    For example on pressing the Macro button present in workbook2 the grid will be updated as shown below


    image3.PNG




    CAn anyone help me ?

  2. #2
    Registered User
    Join Date
    04-20-2012
    Location
    St. Louis, Missouri
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Macro for iteratively updating a grid based on inputs

    If I understand you correctly, you want to update workbook 1 to add the appropriate values found in workbook2? Is there a particular reason why these sheets are in different workbooks, and why isnt the date on the second sheet in the same row as the values? Why isnt 4/21/2012 in B1?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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