Transffering variable data

Closed
Report
Posts
3
Registration date
Friday October 30, 2015
Status
Member
Last seen
October 31, 2015
-
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