View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gunti Gunti is offline
external usenet poster
 
Posts: 58
Default 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?