Creating a macro for data input.
Hi,
I want to create a macro that does the following:
I want people to press a button (for example). Then enter a number (in a
textbox for example), whereafter the macro checks where the next empty row
is. Then fills this row with info found by VLookup() (or Offset()). Basicly i
want to use this to add info to my excel sheet, not manually putting it in.
Any info on how to do this?
|