help in making code run faster

hi,

is possible for my macro code to make it run faster ?

what the copy button do in the "1 NOOH" excel file do is
i manually select a num on column E click copy button
based on the selected num on E it searches on column A
the same num, if found it copies the corresponding name on column F
to the num on column A, it goes on until it searches all the num in column A
then it copies the data to the "1 ST" file starting in A12
i just select another num in E on "1 NOOH" then click copy again to add others

what the sort button do in the "1 ST" file is
it sorts the dates with the same date to its in(am) and out(pm)

i feel its too slow when i have thousand rows of data to process

try this:

Please Login or Register  to view this content.

hi,

thanks for the code
how do i copy it instead to just the st excel file?
i dont need to create a workbook everytime i select a num
the same idea as my original code

how do i make the dates on the appended and sorted format "ddd-mmm-dd" (ex Thu-Dec-29) ?

amended:

Please Login or Register  to view this content.

hi,

thanks again
sorry i was not clear
how can i select a num click copy then select again another num then click copy (and so on if need be)
and it just appends the (name,date,in,out) starting in the 2nd empty cell in column A after A12 in the ST file
(it does not overwrite if there is a previous copied num) same idea as my code

also the date, after append and sort , in column A in the ST file is formatted as number and not as date
even after i format the column as date and save the ST file then run again the macro
it reverts to number format (it shows the date as ex. 475678)

tried to add the "ThisWorkbook.Activate" before the end sub in the code but does not work
how can i go back automatically to the NOOH file after i click ok the message box "APPENDED & DATE SORTED"

thank you! works great!