Hi Guys,
Thanks for you help. Below is new code I am using after your comments. I tried reming the select sheet and un unremming your with sheet idea and it never selects the "Detailed Measures" sheet. Instead it just inserts the rows on the "TREAT data" sheet. I have attached a simple version of the problem. Be aware I can't just copy the whole table and paste as transpose b/c there is actually more data in the column that I want and will add more code once I get this row to work.
Thanks,
~RUTH~
Bookmarks