I have this worksheet (WS) that has many queries and formulas and it automatically starts everyday at 6AM. I need to email the users a copy of this WS but not all the queries, only the results of the query. I thought if there was a way to copy (not manually copy and paste) the original WS and a specify range of cells to another WS then I could save this worksheet and email it off to my users. Any help or thoughts would be very much appreciated.
John
John