Results 1 to 10 of 10

Macro for linking cells from different rows to a specific place on other worksheet

Threaded View

buckhunt122 Macro for linking cells from... 06-27-2011, 04:40 PM
realniceguy5000 Re: Macro for linking cells... 06-28-2011, 11:23 AM
buckhunt122 Re: Macro for linking cells... 06-28-2011, 11:37 AM
realniceguy5000 Re: Macro for linking cells... 06-28-2011, 12:49 PM
realniceguy5000 Re: Macro for linking cells... 06-28-2011, 01:31 PM
buckhunt122 Re: Macro for linking cells... 06-28-2011, 01:51 PM
buckhunt122 Re: Macro for linking cells... 06-28-2011, 01:27 PM
  1. #1
    Registered User
    Join Date
    06-24-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    36

    Macro for linking cells from different rows to a specific place on other worksheet

    Hey RealNiceGuy, I am seeking a VERY similar solution. I decided it might be better to post here than flood the forum with a new topic. Attached is my excel file let me give you a little background: (This sounds way more complicated than it is I promise)

    This a spreadsheet for making estimates.

    1.) When you enter the spread sheet click on the requirements tab, you will see a gray buttton on top of yellow cells. Click that button.
    2.)3 things just happenend
    a listbox popped up, populated from a list on a hidden sheet.
    4 columns, titled by the selection, just appeared on that requirements sheet.
    A spreadsheet titled by the selectino just appeared.
    3.) As you can see those 4 columns are seperate groups, each colum is summed to the bottom in the totals row.
    What i am trying to do is take the 4 new cells in the total row and link it to the cells "A2:D2" on that applications corrosponding spreadsheet. each time a new app is added, 4 new columns will appear, 4 new total values will need to be linked to that new app's spreadsheets "A2:D2" cells.

    As new line items are added and new values placed in those columns the total will change, as those totals change I need the cells linked so the totals on the other spreadsheets change as well. I tried doing this in a very similar fashion to the above file, but I wasnt quite able to get it to work. (my code is on requirements sheet)

    Thank you so much in advance.
    Attached Files Attached Files

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