Transfering Data from two different sheets

alexB588

New Member
Joined
Nov 6, 2017
Messages
3
Ok so I am not an expert at excel, but I know basics on how to pull from different sheets.
That being said my issue is:
I have Sheet 1 (Builder List) that contains all the builders that I work with, you will notice there is an empty column that is labeled "Total YTD Price". I want to transfer data from Sheet 2(Project Tracker)Column F that is labeled "Total Project Cost"

Builder List-----------------------------------------------------------------------------------------------Project Tracker​
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Sales Rep
[/TD]
[TD]Builder Name
[/TD]
[TD]Total YTD Price
[/TD]
[/TR]
[TR]
[TD]AB
[/TD]
[TD]Great Northern Construction
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AB
[/TD]
[TD]Portside Construction
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: right"]
<tbody>[TR]
[TD]Builder Name
[/TD]
[TD]Total Project Cost
[/TD]
[/TR]
[TR]
[TD]Great Northern Construction
[/TD]
[TD]$23,000
[/TD]
[/TR]
[TR]
[TD]Portside Construction
[/TD]
[TD]$38,000
[/TD]
[/TR]
</tbody>[/TABLE]







Example.) Sheet 1(Builder List), B37 is my builder "Great Northern Construction". I want all the price data from sheet 2 (Project Tracker) for all of my Great Northern Construction projects to have a running total on sheet 1 (Builder List). I will eventually do that for all my builders but I cannot figure out the formula on how to do it.

Any feedback would be appreciated.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
I have already responded to this on your other (duplicate) thread regarding this :)
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,906
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top