Pull dynamic rows from several sheets into one

**JordanA** · 01-19-2011, 11:21 AM

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

**royUK** · 01-19-2011, 11:31 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**JordanA** · 01-19-2011, 11:42 AM

Thank you RoyUK, I hope my new title fits better with what the forums require. I do a lot of work in excel so starting out on the right foot here is important to me.

Thank you again.

**JordanA** · 01-19-2011, 09:51 PM

Is this even possible? or am I a dreamer when it comes to this?

**JordanA** · 01-20-2011, 10:43 AM

Is there maybe a macro that when I click a link in a cell it opens a new excel or even a word window with the info I need pulling from the excel sheet they just filled?

**royUK** · 01-20-2011, 11:07 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!