Results 1 to 7 of 7

Pull dynamic rows from several sheets into one

Threaded View

  1. #1
    Registered User
    Join Date
    01-19-2011
    Location
    Jackson, Mich
    MS-Off Ver
    Excel 2007
    Posts
    11

    Pull dynamic rows from several sheets into one

    I am creating a construction worksheet for my crew for quotes. I have several tabs that hold items for different parts of the construction process (Rough, Electrical, Plumbing, HVAC, Walls, etc etc etc) What I want to happen is whenever a quantity is entered for a item information for the row will transfer into the quote sheet for each tab all displaying in the same quote sheet.

    For example the quantity goes into Column E, so a number in the E column will result in a output of E F - B - L - M - N on the quote sheet for the row the number is in.

    Giving an example display of:
    1 Ea Unit heater, gas, 125 MBtu $170.00 $1,025.00 $1,195.00

    I attached an image to show the screen of one of the tabs

    Any help is much appreciated
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by JordanA; 01-20-2011 at 12:33 PM.

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