Hi
in earlier I got assistance from Marc L .
the code will repeat copying name(textbox1) to column B , number(textbot2) to column C for the empty cells . every time I will add data and there are empty cells for columns B,C . I put the result how should be after filling on userform and how should copy to sheet as in columns J,K as examples .
should ignore this case if columns B,C are filled , then just search for next empty empty cells in column B,C and fill them
so now I want searching for sheet name based on matching with optionbutton name( optionbutton name= sheet name) then will fill empty cells for columns B,C as the orginal code does it.
thanks
Bookmarks