Hi all,
I am running a simple formatting macro which worked just fine in 2010, but here in 2016 is giving me some really funky results. I am using the Macro Recorder and not using relative. When all said and done the spreadsheet moved most all columns far to the right when I never had it insert columns on the HTR tab. Can someone take a look I have attached the raw test data with the Macro I setup and please help me fix my code? The Med Admin tab seems to have worked, it is the HTR tab that is throwing me off.
Also, once this is corrected, it would be nice to have on both tabs the auto filter pre populated and sorted by "CHARGE NOT FOUND" and on the HTR tab auto filter and sorted "ORDER NOT FOUND".
I have seriously tried this 30 times and I do not know why the HTR tab is acting funny.
Thanks for the assistance.
KT
Bookmarks