sh1

Hi - i have data on sheet1 from A5 to O200. This data is divided at various points with subtotals. Right now i use 3 different versions of the same code to move a row to another sheet when Cloumn J = "Closed" the code for this is below. Is there a way to use only 1 code and move it to Sheet2...

Hi all, I have created the below macro that will check the dates in column 8 on sheet1. It will then copy the row and paste the data onto sheet2 if the date is less than or equal to cell "K1". The macro is working perfectly but i'm struggling to tell excel to delete the the row after it has...

Hi everyone, I'm new at this. I copied the below code from one of the thread. It works perfectly but I want to make it loop until I decide to cancel it. Thanks in advance. Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dim sh1 As Worksheet, sh2 As Worksheet Set sh1 =...

Hi Can someone help? I have an excel workbook with 2 sheets (SH1 & SH2). The sheets are password protected so SH2 cannot see the information in SH1 In SH1 I have data in several rows SH2 I have mirrored only certain rows (to hide certain information) What I need to do is add a column in SH2...