move a row

I am creating a lead workbook that can flow to other worksheets in the workbook when the status of the lead changes. I have a dropdown box currently that shows from each worksheet what the status can change to. I have copied and pasted some VBA modules data I found online and it works for one...

I am creating a tracker that will be used as a live sheet. It will be accessed by numerous people and consistently updated. There will be an active tab and a closed tab. On the Active tab, the cells on row N contain a drop down. The drop down options are "In Progress" and "Closed". The goal is...

I have a workbook with a sheet called "In Use" where my current data is, spanning columns A through O. In column O, I will enter "yes" when the row is complete and would like this to signal that the row's data should move into another sheet in the same workbook called "Old Reagents". I'd like...

Hi, all I'm Creating a job board where I need a row moved from a "Working Jobs" spreadsheet to a "completed Jobs" spreadsheet once the checkbox for said row has been checked. Can I get some assistance with this? Thanks!

Hello, I'm trying to combine 2 worksheet_change codes and I can't seem to get it figured out. I'd really appreciate some help. Here are the 2 codes separately: Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents = True On...

Hi, I have a spreadsheet with 3 identical worksheets. On all, Columns A to F are used and row 1 is headers. I want to create a button on the "Input" worksheet that when clicked scans column F and: 1. If the cell value of column F for the row is "In", move relevant row(s) to "Current Stock"...

Hi guys. I'm Excel noob and I've got a sorting task to do. Manually I will do it for ages. That's why I'm kindly asking for your help. I have a list of url links like this: and I would like to move every second row to a column next to the previous row and delete empy row. So it should look...

Good day, I am carrying out an analysis of data submitted. the nature of the analysis is to seek variances in the data. one of the variances is multiple submissions on the same data. what I am aiming to do, is to cut all the first occurring duplicates to the bottom of the data. I have already...

I'm new here, but have been browsing post for a while now. I've found some posts that are similar to what I need, but not quite what I am looking for. I have a file that has 22 sheets, all the data is in sheet1, and I need to move the rows (columns A-W) based on the value in column U. I also...

Dear all, I am a beginner here. I would like to ask a help for someone who can help me to solve the problem. I have around 800 data in excel and I want to move data from one column to different column and row. It is difficult to say here, I will give the example in the table below. Please...

Hello everyone, I'd like to know if it's possible to use a macro to be able to move any row (it mustn't necessarily be the first or the last one) from a table to another one, set in another sheet. If it is possible, I'd appreciate to learn how to do it, too, with your help. I link you an...

I discovered another thread close to something I am trying to do. Automatically move a row to another sheet based on cell value I am trying to do pretty much the same thing but with a button and with the copied data from columns A-M only going to 3 places at once, another sheet in the same...

Hi, I have a working version of code that is in need of some optimization and a few tweaks to make it function as intended. It contains no errors, but the output behavior is not as expected. I have a Sheet called "Transaction Data" and "Digital Payments" that I am pasting data into each day...

Hi Guys, I want a code that moves a whole row from one tab to another when there is the word done in row L. This would run on the press of a button. I have the below code, just not sure exactly how to adapt it to delete the row Sub CopyDone() Dim c As Range Dim j As Integer Dim...