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"
<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.
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.