emp enters data and gets work list emailed

[juniormaxx]

i've currently got an excel spreadsheet where employee's go and put there name and employee number and then highlight the selected work and it will be emailed to them.

what i really want is a box on sheet 1 where an employee can enter a number "50-500" and their employee number in another box and have their name updated to next amount requested and updated to the spreadsheet on sheet 2 in Cells D7 on.

the employee number would update starting at sheet 2 D7 and to find the next available empty data would be in column D and would end at a variable number in column D that would be updated in sheet 2 Cell C3

i want it to open and update excel and send it as an attachment. (mine's doing it now.)

there has to be a better way. so i'd really like someone who knows what they're doing to help the less fortunate out.
any help is greatly appreciated.

here's my macro.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)