Posts by crow

    Hi Folks


    I wish to CLEAR the (specific) contents on one sheet 1 (huge range) if that specific info had been DELETED on sheet 2 (a dynamic list).


    My experience in coding is not not that good at all.

    I code by looking for similar examples on Google.

    Let me explain. I have a workbook with two sheets, called Allocation and Teachers. On Teachers is a DYNAMIC LIST called Educators.

    Whenever a DELETE a name (given by NM, JH , etc.) from the dynamic list (on the sheet called Teachers), ALL CELLS that contain instances of the DELETED name,

    on Allocation, must be CLEARED of its contents.


    The range on Allocation (from which the name (i.e. NM, JH, etc. must be cleared) is F9:OP38.


    I have slapped together 2 Subs in Module 1, but neither of them works.


    Please help

    Thanks again for your patience.

    Eric


    Forum2.xlsm

    Hi folks. I am setting up an invigilation roster in which an educator can only be used once per day per class. If you attempt to assign the educator again for the same day
    then Excel warns you and delete your second assignment of the educator. I can do this for one day, and it works for one day. I struggle have this done for, say, 10 days.


    The abbreviations on the right are the codes referring to teachers. The numbers refer to the teacher being placed per day (should be once).
    My code for the topmost row (teacher ZAM) is as follows:


    Please help.


    Thanks in advance.
    Crow


    Note the attachment

    Hallo folks
    I have started an application in Excel.
    Column 1 or A contains codes of people names.
    I want the vba code to find the next empty column (which will be B).
    I want to place data in B until i have reached the length
    of FILLED column A (Find the next empty row in column B)


    Only then I want the code to find the next empty column.
    The code to find the next empty column is as follows and works just fine:


    Dim NextEmptyCol As Long
    NextEmptyCol = Cells.Find("*", [A1], , , xlByColumns, xlPrevious).Column + 1



    MsgBox "Column Number" & " " & NextEmptyCol & vbCr & _
    "Or column letter """ & Replace(Cells(1, NextEmptyCol).Address(0, 0), 1, "") & """", vbInformation, "The next empty Column is ..."



    [TABLE="width: 500, align: center"]

    [tr]


    [td]

    A

    [/td]


    [td]

    B

    [/td]


    [td]

    C

    [/td]


    [td]

    D

    [/td]


    [td]

    E

    [/td]


    [/tr]


    [tr]


    [td]

    Teachers

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    AC

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    PT

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    JC

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    WT

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]
    I need assistance filling column B with data until the length of filled
    column A had been reached. I can use all assistance I can get.


    Thanks folks.

    crow

    Hallo good people. Greetings to you.[TABLE="class: grid, width: 500, align: center"]

    [tr]


    [td][/td]


    [td]

    A

    [/td]


    [td]

    B

    [/td]


    [td]

    C

    [/td]


    [td]

    D

    [/td]


    [td]

    E

    [/td]


    [td]

    F

    [/td]


    [td]

    G

    [/td]


    [td]

    H

    [/td]


    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    Learner No

    [/td]


    [td]

    1

    [/td]


    [td]

    2

    [/td]


    [td]

    3

    [/td]


    [td]

    4

    [/td]


    [td]

    5

    [/td]


    [td]

    6

    [/td]


    [td]

    7

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    March

    [/td]


    [td]

    3

    [/td]


    [td]

    3

    [/td]


    [td]

    2

    [/td]


    [td]

    1

    [/td]


    [td]

    3

    [/td]


    [td]

    2

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [td]

    June

    [/td]


    [td]

    1

    [/td]


    [td]

    1

    [/td]


    [td]

    3

    [/td]


    [td]

    2

    [/td]


    [td]

    1

    [/td]


    [td]

    3

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    Sept

    [/td]


    [td]

    2

    [/td]


    [td]

    1

    [/td]


    [td]

    3

    [/td]


    [td]

    2

    [/td]


    [td]

    1

    [/td]


    [td]

    1

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    5

    [/td]


    [td]

    December

    [/td]


    [td]

    2

    [/td]


    [td]

    1

    [/td]


    [td]

    3

    [/td]


    [td]

    2

    [/td]


    [td]

    1

    [/td]


    [td]

    1

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [/TABLE]
    In the Excel table above the numbers in red identifies the code a learner obtained for a subject, lets say History. The numbers in blue represent
    a learner a specific learner). When the user selects any of the cells in RED, the corresponding number in blue, at the top of that
    column have to chosen and used in a vlookup or hlookup table to identify the learner from a second table hidden somewhere else.


    My problem writing the code that select/copy the number in blue once the user click any of the red numbers. Can someone help please.
    I thank.
    Eric

    I need assistance in:
    (a). Keeping a combobox placed on an Excel worksheet in view as you scroll down on the Excel sheet AND
    (b). having made a selection from the combobox, the cursor needs to go to a specific range (cell).


    I thank you.


    crow