hi
ive been having bit of trouble copying only highlighted rows to sheet2,the rows are highlighted through vba using colour 39 and 43 on sheet1 using( macro1,)
that all works , when it comes to copying these over ,(macro5) I can only do one colour or the other,what I would like to be able to do is copy all highlighted rows from sheet1 to sheet2 in order as they appear on sheet1,any ideas please
cheers colin
Last edited by cfinch100; 01-22-2014 at 01:44 PM.
Use this line in macro5:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
hi mumps1
thanks for that, works no problem ,I can not believe it I had done this earlier but would not work for me,could I trouble you one more time ,when I receive the sheet
I manually put in order of date can something be put at the beginning of macro1 to do this
cheers colin
Hi Colin. Try this macro. It will first sort your sheet according to the date and then copy the rows to Sheet2.
Please Login or Register to view this content.
hi mumps1
it does change date but does not select anything only the whole of sheet1, did you forget to put criteria in as in my macro, or am I missing something here,confused
cheers colin
hi mumps1
sorted it was what I thought have played about and works well many thanks
cheers colin
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks