View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rachel Costanza[_2_] Rachel Costanza[_2_] is offline
external usenet poster
 
Posts: 12
Default Global Report only need USA Data . . .

Hello,

We are moving to global reports and they produce data for areas all over the
world. For US clients who do not want to see data outside of the USA I have
to manually delete data for UK, France, Dublin, China, Tokyo etc. and I was
wondering if there was a macro I could run to remove all of the rows with a
location outside of the USA while still leaving the USA data element of the
report in tact.

Any insight is appreciated!

Rachel