VBA to run every month and sorting data from userforms
 

Hi all,

Ive 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 dont 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. Ive 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? Im 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€¦

VBA to run every month and sorting data from userforms
 

Perhaps I should of been more specific and seperated the questions,

If you need clarification please ask..

"Phin" wrote:

Hi all,

Ive 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 dont 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. Ive 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? Im 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€¦