Good Morning all
I have a file that I require to copy data from the main page " Repeater Directory 201217 ", across to
each of the destination pages, then sort each destination page by column " B " from low to high
From the " Repeater Directory 201217 " sheet search for a call sign governed by the numeric number in the 3rd character : ie VK1???, VK2???, etc
All data starting with VK1 gets copied over to the Sheet named VK1,
All data starting with VK2 gets copied over to the Sheet named VK2, and so on
I have manually copied some data over to the sheets VK1 and VK2.
There are several blank rows as that is how the data is supplied to me, These lines separate the different Frequency blocks starting at 29 mHz and going up to 1200 mHz
I have only supplied a cut sample file as the main file is too big to upload
Any clarification please ask me
I have tried to explain in as fewer words as possible.
Many Thanks in advance
Peter
Please Note also posted on the Excel Forum site.