X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Trying To Delete Cells And Shift Up If Contain Text, Office 2010    
post Nov 20 2019, 05:19 PM

Posts: 1,328
Joined: 17-November 13
From: Orewa New Zealand

This sounds simple but I just can not find it ,everything is for delete rows or delete cell for one word but I want to delete cell and shift up if it contains any of these words or someone might have a better way to get the names without holidays in a list
Christmas Day
Boxing Day
New Year's Eve
New Year's Day
Day after New Year's Day
Waitangi Day
Good Friday
Easter Day
Easter Monday
Anzac Day
Queen's Birthday
The list is a named range call clients and comes from a table by a macro
Application.CutCopyMode = False
    Sheets("All Dates").Range("Table2[[#All],[Name]]").AdvancedFilter Action:= _
        xlFilterCopy, CopyToRange:=Range("E2"), Unique:=True

Its basically all the new Zealand holiday names I dont want just the peoples names in a named range so I can use it elsewhere.

The names in the ALL Dates table are imported from my outlook calendar so I can not change that I also need the holidays elsewhere in the workbook
This post has been edited by wornout: Nov 20 2019, 05:20 PM
Go to the top of the page
post Nov 20 2019, 06:12 PM

Posts: 1,328
Joined: 17-November 13
From: Orewa New Zealand

Ok One soultion I got was to do a pivot table and filter the table and then do a named range from this . BUT if anyone else has a diffrent way please let me know
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    12th December 2019 - 08:11 AM