All I want is to create a macro so all information related to a single company goes to its own tab.
Like for example there is 6 entries for Company A ltd, I want macro to instruct that it creates a new tab for "A Ltd" with name of A Ltd and copy all information related to A ltd into new tab, as I had created a tab for A ltd…. I have 150 different companies for which I have to create a tab and copy paste there related information Manually..Please help
Also Macro self creates new tab when new company added in the list
PleClient as on May.xlsxase find attached file....
Bookmarks