VBA code to move contents from one cell to another
I want to create a page in Excel (lets call it page 1) where I can enter a
Job Name, and once entered, click a button and have that Job Name move to the
next available space on a master Job List, located on another page (page 2).
At the same time I want the Job Name entered on page 1 to disappear, so I can
enter another Job name and repeat the process. I have not used VBA before,
but it sounds like this may be possible through code. Any help would be
appreciated. Thanks.
|