I am new on this forum and, also, on VBA coding.
I'd like to ask you a little help in order to have a VBA macro code to solve the following problem:
I have an enquiry table in which column A and B are serial numbers and column C is a question, but can also be a title. My rows start with cell 25 (there is header above).
In column "B" I wrote (typed) the serial numbers, skipping the cells that have adjacent (in column C) blank ones.
There is a cell inside the worksheet which allows the user to select (dropdown list) a certain category of queries and thus, there are remaining only the relevant rows.
I have a VBA code that hide the rows that don't fit with the queries category and also, in the end of the macro code there is the below code that automatically inserts serial numbers in column A, based on hidden rows but ... this is my real issue ... I don't know how to run this code (or, maybe, I need a second one ... ) in order to take into account and skip the blank cells in column B.
this is the existing and ... incomplete code :
e.g. C1=title, C2,C3 =questions, C4=title
B1="", B2=1, B3=2, B4=""
If I choose (select) question type C2, then: A1="", A2=1, A3=hidden, A4="" or hidden, and so on
Thank you so much in advance for your support and I appreciate your kindly effort to spend your time and share your knowledge.