Hi ,
Is there a way that I can split data into separate sheets,by AGENT ??, since this file is not created by me ,hopefully the VBA can be use in other succeeding sheet as long as the format is the same .Thank you
Hi ,
Is there a way that I can split data into separate sheets,by AGENT ??, since this file is not created by me ,hopefully the VBA can be use in other succeeding sheet as long as the format is the same .Thank you
Last edited by mscarrie; 07-17-2019 at 09:31 PM.
This is almost identical to a recently asked question: https://www.excelforum.com/excel-pro...orksheets.html
See if you can adapt the answer in that thread, to suit your requirement.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
It didn't help me .I don't know what to do.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks