Forum

Andy KA
@andykauk
Eminent Member
Joined: Feb 15, 2021
Last seen: May 3, 2025
Topics: 4 / Replies: 12
Reply
RE: How to Copy filtered subtotal to another sheet

Hi Anders Thank you ever so much it worked however, it works when both workbooks are open. Is there a way to tidy up the code below and make the...

4 years ago
Forum
Reply
RE: How to Copy filtered subtotal to another sheet

Hi JESSICA Thank you ever so much for the clip. However, I don't wants to extract any list. For this I could use index match but what I want is ran...

4 years ago
Forum
Topic
Forum
Replies: 5
Views: 108
Reply
RE: How to Extract Subtotal values when filter by color applied

Hi Mynda Thank you for the reply. Please help me with VBA. All i want filtered results to be copied over to another sheet. Thank you

4 years ago
Reply
RE: How to Extract Subtotal values when filter by color applied

Hi Anders Actually there is logic. There are specific names in Column G that are filtered when I apply Light Grey filter in Column B. AND There ar...

4 years ago
Reply
RE: How to Extract Subtotal values when filter by color applied

Hi Mynda I have attached the original spreadsheet that may give you more information to determine what I am looking for. I am filtering data in ...

4 years ago
Reply
RE: How to Extract Subtotal values when filter by color applied

Hi Mynda Thank you for the reply However, thats, not what I am after. I have over 1500 rows on sheet one. So When I apply the filter The values cha...

4 years ago
Reply
RE: Highlight Row based on Hours by the minutes with additional criteria

Thank you ever so much Anders I will build up on the basis that you have provide. Once again thank you ever so much for your guidance. Andy

4 years ago
Reply
RE: Highlight Row based on Hours by the minutes with additional criteria

Hi Anders Thank you so much for good Start. Yes! You're correct again. I will need more advanced format. Would you be able to help me with this ple...

4 years ago
Reply
RE: Highlight Row based on Hours by the minutes with additional criteria

Hi Anders You're Correct. Time will be 00:25 and yes Partially Thurs should also be highlight but for only 25min (12:25am). I am looking forward...

4 years ago
Reply
RE: Highlight Row based on Hours by the minutes with additional criteria

Hi Anders. My Apologies. I will reload it now. Please see the attached. Thank you ever so much for your expert support in advance.

4 years ago
Reply
RE: How to Extract Start and Finish Date by Year

Thank you both Jessica and Anders for excellent solutions.

4 years ago
Reply
RE: How to Extract Start and Finish Date by Year

My Apologies. Please see the attachment.

4 years ago
Page 1 / 2