Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm to delete unwated items off sheet?
Hi All
We are an Angling Club and when we have Matches the entrants can enter various Pools which are listed on the entry form as A,B,C,D,E,F,G - on a UserForm I enter all the entrants details name etc plus what pools they have entered in Textboxes the pools are entered in columns K : Q starting at row 6 e.g. J. Bloggs A,B,C, - next row -- J. Smith A,B,C,D, etc -- an Angling Match is decided by the weight caught by each individual Angler the weights are sorted in column J highest to lowest. We only payout 3 prizes in each pool 50%,30%,20% -- my problem is that on the sheet there will be many A,B,C,D,E,F,G entries some with blank cells in between in each of the columns and all I need is the first 3 A's B's etc and I need all the others deleted is it possible that someone can help with a macro that would do this for me. -- Many Thanks Sue |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete items | Excel Discussion (Misc queries) | |||
Listbox has some items selected when userform containing it opens. | Excel Programming | |||
userform delete sheet | Excel Programming | |||
userform delete sheet | Excel Programming | |||
Deleting unwated control characters at the end in a particular column | Excel Programming |