excel auto copy and paste

I would like to develop a VBA that automatically copies entire row info from specific row on Sheet1 and pastes it into next available space in table on Sheet2 based on date info in column G (any row where date is older than 60 days/highlighted in red). Table in Sheet2 is virtually identical to...

Private Sub CommandButton1_Click() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA") lastrow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row For rownum = 2 To lastrow Select Case...

Hello. First of all thank you that you are willing to help. This is much appreciated! I am new to Excel (but I know how to apply macros) so please excuse the fact that I don't express my mind with a proper technical terminalogy. English isn't my native language. Hopefully you will...

Hi all I have an enquiry here and would like a workaround. I am an IT support consultant and want to maintain my own report of the issues I receive daily. I would like to have a spreadsheet with tabs created daily. E.g Each tab is created once daily and named as '2014-06-10', '2014-06-11'...