+ Reply to Thread
Results 1 to 3 of 3

Copy value from specific cell in each comp sheet into appropriate cell on the main sheet

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Copy value from specific cell in each comp sheet into appropriate cell on the main sheet

    Hello. I have a spreadsheet that i use for my company to do engineering estimates for our projects. With other people's help from these forums I have created a macro that copies a template sheet to create individual sheets for each engineering item in a list on the main sheet. The macro creates all of the sheets and then each item is estimated in each sheet and the total value ends up in cell H77.

    The main sheet also references the total quantity from cell H77 for each specific sheet and that quantity is in the same row as the corresponding item in the list. However as of now I have to do this typing by hand in each cell in order to reference the total quantity in the correct sheet. For example, the engineering item number in cell B11 on the main sheet is entered as '201.06 and there is a calculation sheet that has been created for it already. This calculation sheet (and all calculation sheets) has a total quantity in cell H77 which needs to automatically update in cell D11 on the main sheet. In order to reference that total quantity into cell D11 I type '201.06'!H77 which brings it in for me. When I have several hundred items this takes a long time.

    I would like to create another macro or something similar that automatically populates column D on the main sheet (starting with D11 and ending when there are no more items in row B) with the correct quantity for the item in column B. Example:

    Column A Column D
    '201.06 '201.06'!H77
    '202.06 '202.06'!H77
    '202.07 '202.07'!H77
    'XXX.XX 'XXX.XX'!H77

    Therefore, Column D would have the text 'XXX.XX'!H77 in each of it's cells after the button is pressed.

    Thanks in advance for any and all help!

  2. #2
    Registered User
    Join Date
    06-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy value from specific cell in each comp sheet into appropriate cell on the main she

    Column A Column D
    '201.06 '201.06'!H77
    '202.06 '202.06'!H77
    '202.07 '202.07'!H77
    'XXX.XX 'XXX.XX'!H77

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy value from specific cell in each comp sheet into appropriate cell on the main she

    Correction
    I would like to create another macro or something similar that automatically populates column D on the main sheet (starting with D11 and ending when there are no more items in Column B) with the correct quantity for the item in Column B. Example:

    Column B___ Column D
    '201.06 ___ '201.06'!H77
    '202.06 ___'202.06'!H77
    '202.07 ____'202.07'!H77
    'XXX.XX ___'XXX.XX'!H77

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 07-18-2013, 02:34 AM
  2. [SOLVED] Bulk import. (Copy Data from one sheet to a main sheet with conditions)
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 12:24 AM
  3. Copying from main sheet to new sheet if cell contains certain text
    By fitzegee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2011, 08:10 AM
  4. Replies: 4
    Last Post: 03-09-2011, 05:25 PM
  5. Copy specific columns to specific cell on new sheet
    By jones_net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2010, 02:34 AM

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