G
Guest
Hi all,
I’ve two problems that I cannot seem to find answers to. Any help or
suggestions would be gratefully received…
1) For the purposes of recording progress, I wish to copy/paste data from
one worksheet to the next available row or column in another, on the same day
every month. I don’t mind which day as long as it is a weekday and consistent
(i.e. first Friday of the month). It would be good if this were on an
infinitely recurring basis. I’ve looked, in confused vain, at the OnTime
Procedure, but to no avail.
2) The second is to do with User Forms. I have a general idea how to create
one, which would include Department, Position, Name and other info. But, is
it possible to insert this information into a database that is sorted first
by Department, then position, then by name? I’m sure its something to with
finding the closest match, but am not certain either if this is correct or,
it were, how to implement it.
Thanks in advanced for your advice…
I’ve two problems that I cannot seem to find answers to. Any help or
suggestions would be gratefully received…
1) For the purposes of recording progress, I wish to copy/paste data from
one worksheet to the next available row or column in another, on the same day
every month. I don’t mind which day as long as it is a weekday and consistent
(i.e. first Friday of the month). It would be good if this were on an
infinitely recurring basis. I’ve looked, in confused vain, at the OnTime
Procedure, but to no avail.
2) The second is to do with User Forms. I have a general idea how to create
one, which would include Department, Position, Name and other info. But, is
it possible to insert this information into a database that is sorted first
by Department, then position, then by name? I’m sure its something to with
finding the closest match, but am not certain either if this is correct or,
it were, how to implement it.
Thanks in advanced for your advice…