Transffering variable data

bigdridog Posts 3 Registration date Friday October 30, 2015 Status Member Last seen October 31, 2015 - Oct 30, 2015 at 11:23 AM
Hey guys,

I have a report I do every 2 hours at work through excel. I have two reports that go into a macro and it's ran to go into several different tabs. What I want to do is from that macro (that's changing every 2 hours) is create a tab that I can catergorize the information rather than keeping it in a long column. I hope this makes sense. I don't want to just transfer data because it's not always the same location. I.e a supervisor has 12 different accounts each has a date and how many items to process. I want to put per supervisor their clients experiation dates and how many items needed to meet their goal. I hope I painted a clear picture lol makes sense in my head