Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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€¦ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Consolidating/summarizing and sorting data | Excel Worksheet Functions | |||
Sorting data within the same row. | Excel Worksheet Functions | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
sorting data by date | Excel Worksheet Functions |