name insert

[drop4205]

I have about 4 different worksheets that we use at my work depending on retail or wholesale. There are about 10 different people using these worksheets and I am wondering if there is a macro that when the worksheet opens there is a way to have the persons name, email, phone number with extension and date added in cells on the worksheet. I know in coral quattro pro I had a "who am i "program that was save to each persons computer and when they opened up the quattro program they needed it had a pop up the clicked and it inserted all the information of that person to the page they were working on. Trying to get everything swapped over to excel. Thank you

[gmr4evr1]

You can use this to get the user name when they open the workbook. Place the following code in the ThisWorkbook section of VBA.

Please Login or Register  to view this content.

This will place the username in the next blank row of column A.
I think to put the other information in, you would need to add If statements for each user into the code, or use another sheet that has their info and have it automatically add the info into the row needed??

[leelnich]

Hi drop4205- are all of your worksheets in the same workbook, or do you mean 4 different workbooks?

[drop4205]

solved thank you
= left click on cell in workbook 1. Go to workbook 2 and left click on the cell with info that is saved then back to workbook 1 and hit enter to have that cell look for info where I pointed it to

[gmr4evr1]

Glad you got it resolved.

[leelnich]

Hi drop4205- If you're done with your thread, please go to Thread Tools up top and mark it as SOLVED. Thanks-Lee