Pivotal Filter Selection Macro

[mdmackillop]

Hi BMS
When you copy code, use "Paste without formatting" (Ctrl + Shift +V) to avoid the Font tags etc.

[bloodmilksky]

so what I want to send is the results of the ac number selection via the Mail_Range Macro. So I guess the Identifier would be the Account Number? Or the Active Range Of the Pivotal Table ?

[Bob Phillips]

I guess that you mean the rows that are in the source data for the selected account? If so, would it not be okay for us to ignore the pivot and work off the original data, the accounts are all blocked.

[bloodmilksky]

The main reason for this is the way the data is presented. Because it needs to be easily read by the recipient. So needs to have their AC, Email, and the outstanding order numbers with the time that we are looking to resolve them.

I have another spreadsheet that sorts the rows of data in to named ranges(these are the AC Number) and once it has finished sorting them it runs through each ac number range and emails it off.

but I was told that way might have too many problems.

Sorry for this XLD I really appreciate your help I just feel stuck at the moment.

[Bob Phillips]

I have another spreadsheet that sorts the rows of data in to named ranges(these are the AC Number) and once it has finished sorting them it runs through each ac number range and emails it off.

Not sure I am understanding, isn't this exactly what you are trying to achieve?

[bloodmilksky]

Yeah its exactly what I amt trying to achieve but there are some problems I have had with it that exceed my knowledge level.

Could I send it to you to see what you think?