Attached I've included a purged version of a spreadsheet I am trying to make. The tabs are named and the following requested are humbly made to give instructions of the desired function of the macro. For the sheet per Agent Page for all rows where K on sheet1=B2 on sheet per agent arrange info into columns a-e on sheet per agent in the following order n a c f m with information from sheet1. Then do this for all rows that where K sheet 1= b2. I know what I want it to do, but I'm not sure of function that could do it or how to utilize the macro recorder to achieve this goal. There will need to be a macro for the last 3 tabs as well. All the macros will involve pulling info from sheet 1 and inserting it into a certain order on the other tabs based upon criteria. If anyone is able to help with my first issue or any of the additional I'd greatly appreciate it.
Thanks,
-D
Thanks,
-D