Cross workbook referencing without blanks

CreativeRova

New Member
Joined
Dec 12, 2013
Messages
49
Hi, I am looking for an answer to the below issue that I can work in to the actual spreadsheet

The master version has many columns that I have listed below

Master workbook
JulyJulyJulyAugustAugustAugust
ClientAgencyBDMValueFormatNEWStatusMediaProductionQuantityMediaProductionQuantity
SUMSUMSUMSUMSUMSUMSUM
Client 1BlahKaren$10,000AdYESPENDING$4,000$2,00050$4,000$0.0050
Client 2BlahKim$15,000AdNOConfirmed$12,000$2,000100$1,000$0.0015

<tbody>
</tbody>



The above is updated constantly every day.

The sales persons version only shows their deals and sums. There will be 13 tabs on the bottom a summary tab and 12 months. The below is an example of JULY

Sales Workbook
Karen July
Budget$50,000
ConfirmedE9
Difference
% of Budget
LostL9
PendingS9
ConfirmedSum E11:E:2000LostSum L11:L2000PendingSum S11:S2000
ClientAgencyValueFormatMonthly ValueProductionClientAgencyValueFormatMonthly ValueProductionClientAgencyValueFormatMonthly ValueProduction

<tbody>
</tbody>


So I need A11 to pull the info from the master workbook. but only the selected info not every line. It also needs to only show in the July tab if there is an amount in July if the Media amount is in August Media then show in the August tab.

Pull the relevant info leaving no blank rows.

This list needs to update automatically from the master sheet, no blank rows so can be printed if needed.

Thanks.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,569
Latest member
Honeymonster123

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