LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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€¦

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidating/summarizing and sorting data Len B Excel Worksheet Functions 0 December 5th 06 09:42 AM
Sorting data within the same row. aequanimitas Excel Worksheet Functions 1 August 29th 06 06:13 PM
Vlookup to Return a Range of Data James Excel Discussion (Misc queries) 0 July 13th 06 09:44 PM
Automatically sorting data leehutch Excel Discussion (Misc queries) 4 August 22nd 05 06:36 AM
sorting data by date Katherine Excel Worksheet Functions 1 June 17th 05 03:12 PM


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"