Hi Guys,
I want to send excel sheet via email to all my staff members to write their latest address.
Are there any possibilities to get the latest address to my copy once they have entered in the excl sheet?
Hi naflasJohn
- How many staff members we talking about?
- What does "your copy" look like
- What does the file you're sending to staff look like
- What's the key between the two files.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks for you reply,
Please find the attached .
Staff can change/enter any data. It should reflect in my copy .
Hi naflas
What is the attached file? Is it your file, the Staff file or are they both the same?
You sayCan they change their name? Is Name the key between the files?Staff can change/enter any data
How many staff are we talking about?
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thats a sample document
Staff number is 33,
Coulmn A is for n staff name. It will not be change
Hi naflas
I've attached four files. File "Your Book" is your copy of the file and the procedure runs from here.
The other files "Apple, Banana and Peach" are files that you would receive from staff. These files look exactly like "Your Book" but are assumed to be Macro free. They can be named anything you like as long as the names are different.
It is assumed that all four files reside in the same folder and that no other Excel (.xls) files are in the folder. It is assumed that all relevant data exists in Sheet1 of each workbook.
Try it and let me know of issues.
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks