Hi,
I've found good answers to questions others have asked here in the past, so figured I why not try.
I'm new to VBA and macros, I normally can do what I want with formulas but not this time.
I currently have a button that asks for two separate text strings:
A Name and A Type.
What I want to do is match the Name with one of the names in the first column.
If a match is found I want it to fill that row based on the column headings (search all column headings for Type).
Any cell in the row with a column heading that contains the Type within its string, will be filled in with the entered Name & Type strings joined together.
Example:
<tbody>
</tbody>
I'm not worried about overwriting things when a new type is entered for my use that won't be a problem.
Any help on what this code should look like would be really appreciated, I haven't been having much luck.
I've found good answers to questions others have asked here in the past, so figured I why not try.
I'm new to VBA and macros, I normally can do what I want with formulas but not this time.
I currently have a button that asks for two separate text strings:
A Name and A Type.
What I want to do is match the Name with one of the names in the first column.
If a match is found I want it to fill that row based on the column headings (search all column headings for Type).
Any cell in the row with a column heading that contains the Type within its string, will be filled in with the entered Name & Type strings joined together.
Example:
AaBaCaDa | AbBbCbDb | AaBbCbDb | AbBaCaDb | |
ALAT | ||||
ALGT | ALGTBa | ALGTBa | ||
CAP | ||||
ZAP | ZAPAb | ZAPAb |
<tbody>
</tbody>
I'm not worried about overwriting things when a new type is entered for my use that won't be a problem.
Any help on what this code should look like would be really appreciated, I haven't been having much luck.