Greeting Professionals,
This will be my first of many posts on this forum. I have searched and used many of your solutions over the past few weeks and they have all been helpful!
The preface here is that I am a novice with formulas and am just now getting my feet wet.
Scenario:
In one workbook I have a drop-down list of clients residing in Cell CV4. I also have the selected client name copied the cell below CV5.
In Column CU (beginning at cell CU7) I have a list of Months.
I also have reports from individual dispatchers in separate Workbooks (each dispatcher report is formatted identically).
In the dispatcher report I track sales by client by month.
Task:
I need to enable the first Workbook to sum total sales by client across all dispatcher reports according to the selected client name from the drop-down selection.
I tried to include attachments of the Workbooks, but am not allowed to attach files.
I would like to formally thank any and all of you in advance for any help you can provide!
This will be my first of many posts on this forum. I have searched and used many of your solutions over the past few weeks and they have all been helpful!
The preface here is that I am a novice with formulas and am just now getting my feet wet.
Scenario:
In one workbook I have a drop-down list of clients residing in Cell CV4. I also have the selected client name copied the cell below CV5.
In Column CU (beginning at cell CU7) I have a list of Months.
I also have reports from individual dispatchers in separate Workbooks (each dispatcher report is formatted identically).
In the dispatcher report I track sales by client by month.
Task:
I need to enable the first Workbook to sum total sales by client across all dispatcher reports according to the selected client name from the drop-down selection.
I tried to include attachments of the Workbooks, but am not allowed to attach files.
I would like to formally thank any and all of you in advance for any help you can provide!