Gather data and display in certain order

[Potholes]

..

Good afternoon all


Attached is my Temp work sheet a VERY VERY much cut down in the data department.


Previous coding allowed for on the "Master" sheet in cell "C1" if "FM " is selected from the list below, (which is in Column L on the " Templates" sheet), and "C3" automatically displays "Blank" and a Call sign entered into "C2" then the relative data is displayed for that call sign in panels on the "Master" sheet.

If anything else other than "FM" is selected in "C1", then "C3" automatically goes to "ALL" and what ever was selected in "C1" say " Wicen" then all the data related to "Wicen" is displayed in panels ( it could be up to 150 + Panels on the master sheet ..

.................................
Column L on the Templates sheet,
FM
Wicen
ATV
DStar
23cm
DMR
C4FM
P25
VK1
VK2
VK3
VK4
VK5
VK6
VK7
VK8
..................................
Column K on the Templates sheet
Blank
ALL
...................................

I tried to modify the main code to find the Templates sheet as shown below, but it cannot no matter

Please Login or Register  to view this content.

I have added the following sheets to this program " VK1,VK2,VK3,VK4,VK5,VK6,VK7,VK8 ", so they will fall into the same category as "Wicen, ATV, DStar, 23cm, DMR, C4FM, P25 ", as far as what ever is selected in " C1 " will be displayed on the Master sheet panels.

This is the code that need to be adjusted to allow for the new sheets. ( As the outline of the panels is not showing, DATA is OK.)

Please Login or Register  to view this content.

The following code I would like to know what it does as I have forgotten. ( C.R.A.F.T. Memory, OLD age ), maybe someone could remind me please so I can tag a name to it.

Please Login or Register  to view this content.

I trust there is no problems with this thread..


Many Many Thanks for all and ANY help.

Peter

[Sintek]

As the outline of the panels is not showing

Please Login or Register  to view this content.

I notice you are changing sheets...The above red snippet should be Sheet12 which references Sheet named Template
You have it a referencing Sheet named All Wicen

[Potholes]

Good Evening SINTEK

I trust you are keeping well.

I have tried all sorts of numbers including 12, now it sort of works ( On the Master sheet) When I select say VK1RAC it finds
that OK, but nothing from VK2 to VK8, it finds all the Different modes OK, could you check that I have the Templates L1 to L15 ranged OK under " LIST"


Do you understand my request on the VKsplit code please.


I have re up loaded the files with the mods done ...


Ohhh Why I added sheets to the file, My chief Cook and Bottle washer ( Wife of 50 Years) asked why the 2 similar files why join them into one, hence the new thread.

[Sintek]

Peter...I do not understand per quote below...

When I select say VK1RAC it finds

Please Login or Register  to view this content.

VK2 is not in your list...VK1RAC is not available on VK1, VK5, VK7

For this quote below...I suggest going back to the thread where you got the code to see what you wanted done...

Do you understand my request on the VKsplit code please

[Potholes]

Hi again


Hi I have put my brain into Gear and realised that I need to select VK4 in the drop down box to look at a call sign in the VK4 Category.


I will look back into other threads re the SplitVK code

Many thanks

Good Night