HELP !!How to add values to sheets based on two conditions

[Abo Rawad]

Hello all.

i tried to add the value of a comboBox to the first empty row -in the whole sheet- in column 1, and some other information to the first three empty cells in column to the left.


Now What i need is to Check if the the value of the combobox is already there in column 1 cells then add the information in the first empty column in the left to three cells, If not, add the the value to the first empty row in the whole sheet in column 1 and add the information in the column left to it.


Here is what i tried

Please Login or Register  to view this content.

Thanks in advance for everything.

[HaHoBe]

Hi, Abo Rawad,

you could either use Find to set a range if the value is found in Column A or use WorksheetFunction.Match for that. If either the range is nothing (no item found) or the variable for match delivers an error new data needs to be added while otherwise the range will deliver the row on which to take further action:

Please Login or Register  to view this content.

Ciao,
Holger

[Abo Rawad]

Thank you soooooooooo much , HaHoBe.

This is my code after using your smart idea, it works exactly the way i wanted.
and even shorter and faster than looping.

God bless you, dear

Please Login or Register  to view this content.