move rows to next sheet

Hello I'm trying to move a row from sheet 1 "Chapter to Sheet 2 "Complete" using VBA for instance if A3 = "Cash" and L3 = "Refund" cut copy and paste entire row to Sheet 2 "Complete" and search the other rows if both criteria's are met then cut copy and paste entire row to Sheet 2...

Hello, I have been using a great task tracker that when I enter a complete date, it moves the entire task row to a new worksheet, "Completed Tasks." Here is the issue I ran into: When I archive my year of tasks, I save the excel as the following year, then on the current workbook I delete the...

Hello -- Looking for help with the following situation. I'd like to move an entire row from "Worksheet 1: Pending Items" to another Worksheet based on the value in Column 1 and the Status in Column 3. In my simplified example below (header row in bold), I'd like Row 3 from "Worksheet 1...

I have a scheduling workbook with one sheet that contains information of active jobs and another sheet that is to be used as a job archive. the active job sheet as 2 columns with check boxes for if the job is complete, and if the job has been fully invoiced. Once both of these columns are marked...

Hi! I'm trying to use an old macro on a new worksheet but I'm hoping someone can help with the differences. Originally this macro was used to move rows based on an empty cell in a column. Now I'd like to use it to move rows based on a value in a column. The only thing I can think to do is to...

Hi all, I am trying to combine sections of code to achieve the following: I have three worksheets: “raw data”, “completed” & “quote”. All workbooks have the exact same layout The header takes up row 1 Data fills column A-H. H is a status column with a drop down list, here you can select : “raw...

I have a lost and found log that has 2 worksheets: (1) Unresolved and (2) Resolved. Data is entered into the Unresolved worksheet when something is lost or found. When a date is entered under Date Claimed / Sent to Capitol Police (column I), I would like the data in that row to be removed from...

I pull weekly alarm reports. Each alarm has a different "Process States". The states include: active, inactive, completed and pending. I only need to see the "Active" alarms. The Process State is in column J. The raw report looks like this. The report is anywhere from 40,0000 to 60,0000...

Alright, so I'm really rather new to this VBA thing and I've been doing some research and digging and I can't seem to be able to use anything that I find online to help me with what I need. I've tried changing some code around and nothing seems to work, so I am hoping someone on here could help...

Hi Friends, (With hopes of help) I need help one of the codes which I have recorded. I'm getting error when I re-run it. I have two questions 1) Is it possible to move the entire rows to the next sheet with Criteria and only visible rows. ? Or Do I need to copy to next sheet and then come back...