Need some help on how to add data text into cells using VBA on Excel, without overwriting current data.
What i am trying to achieve is a program in which membership details (Name, Address) are shown via a VLookup, when users enter their Membership ID (E.G "103"). Knowing that a Vlookup requires a table of data, how will i add new members into the data sheet without overwriting the current?
Is there a way to say "If cell "X" contains text, then skip it and move on to the next cell".
Thanks in advance.