WBK1 (shared) has a routine in it which opens WBK2, copies the value
of WBK1-E3, pastes it into Next empty row col A-WBK2, goes back to
WBK1, copies the value of WBK1-B2, pastes it into Next empty row col B-
WBK2, etc, for 11 values – so that WBK2 ends up with a new row of 11
cell-values from WBK1. The routine then sorts the rows in WBK2 by col
A (which are numbers – from E3), saves and closes it, goes back to
WBK1 and clears the 11 cells of their values – ready for the next
entry.
I want the copying and pasting part of this to work for more users -
users who don’t have access to the folder which WKB2 is in (because IT
won’t/can’t be bothered to give them access). Is there any way I can
get this to work for those users, perhaps via the user’s and my
Outlook, ie adjust the copying and pasting routine for the non-access
users to something like this: copy, paste into email, send email to
me, get WBK2 opened on my PC, paste the values from the email into
WBK2???
(The non-access users can be identified from WBK1 by the fact that
there will be an “N” in Sheet1 Cell S27)