selecting cells by date appending/deleting

Sandy01UK

New Member
Joined
Apr 16, 2013
Messages
19
Hello,

I wonder if anyone can assist as I'm just not getting this!

I have dates in column T (Live Master) I need a macro that will firstly select all rows with any date and append to the bottom of the data in Sheet Archive. I then need to delete and rows with dates in column T (Live Master).

I've searched around and not got very far.

Thanks in advance.

Sandy
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Hi progess of sorts! I have managed to find a way to delete all dates/blanks as indicated in my question above. However when appending the to my Archive sheet using
Sheets("Archive").Range("a" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
 
I don't get all the columns as the header row has been deleted and the above only selects columns that have values any suggestions. I'm sure this is not most effecient way of writting this if anyone has any suggestions.
Sub Test()
'
On Error Resume Next

Sheets("Live Master").Select
Sheets("Live Master").Copy Before:=Sheets(1)
Sheets("Live Master (2)").Select
Sheets("Live Master (2)").Name = "master"
Range("N24").Select


Columns("U").SpecialCells(xlCellTypeBlanks).EntireRow.Delete


Sheets("master").Range("a1").CurrentRegion.Copy
Sheets("Archive").Range("a" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("master").Select
ActiveWindow.SelectedSheets.Delete




End Sub

Thanks

Sandy
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,099
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top