Hello once again, I am tasked with splitting apart a report into different tabs so that those tabs can be saved as a .pdf on different pages. Then I need to split those.
I will try to be a clear as possible to make this easy for myself.
-Sorting by Unit number(value) in column B.
-Every one has the same header.
-Each tab has the name of the unit number.
I will add an example of the report I need to break into these tabs.
Basically this macro will search column B for a value then take all rows with the same value in column B and paste it into a new tab with a set header.
Bookmarks