move rows

I am looking for a VBA loop that can move rows from the unsorted table to multiple tables labeled based on staff names without overriding or clearing off formatting as I have a bit of data validation and conditional formatting on the unsorted and staff assignment pages that I need to keep so I...

Hello, I am trying to set up a new document to track clients, I have included a screenshot. For each worksheet, I want to be able to enter the status in column N which will transfer the specific row to whichever worksheet I have specified in the status (New Enquiries, Consultations, Quotes To...

Hi, I currently have a macro that copies and pastes a number of rows from one workbook into a tab in another workbook. Row 1 (Column A to PO) - is the header row Row 2 and down (Column A to PO) is the data This works great, and basically, other tabs in the excel document then look at the...

Hello - I've searched the forum, but not found anything that specifically addresses my issue. I have a task list workbook that contains 4 sheets: Master, Today, Assigned and Done. All tasks are entered in Master, and I want to have the row deleted from Master and moved to the next available...

Hi, Can some excel genius help me out? I have multiple worksheets, lets say Sheet1 to Sheet 10 Depending on the Value in Column A, the whole row should be moved to the first empty row in the respective sheet. E.g: Value A --> Sheet 1 Value B --> Sheet 2 Value C --> Sheet 3 ….. However...

Hello, I am trying to use VBA code in order to move entire rows from sheet1 named "New Projects" to 3 different sheets, based on cell value picked from in-cell dropdown list in sheet1. I am not a coder but I could understand a little and fond a piece of code somewhere on the internet. So far...

I have a workbook with multiple worksheets and want to create a command button that moves rows in one sheet to another. In the “Master” worksheet, if “Column U” has an “X” in it, I want to move the entire row to the next empty row in “Scrap” worksheet and delete the original row in the...

Hi All Firstly, please let me apologise for my total lack of knowledge - This is my first foray into the world of VBA and I'm finding it extraordinarily difficult. So, (bearing in mind that my experience is zero), could you please help. i have tried to look through previous answers, but I'm...

Hi The code posted by texaslynn in the link below works perfectly for the beginning of what I'm trying to do. However, I already have a tab with a name that matches one of the data names in the column that is being broken out. When the macro runs, the already created tab is overwritten with...

I have a list of properties that I constantly add to, and each of these properties has a column with a date expressing when its loan expires. I want to create a macro that I can run everyday that will automatically pull out the properties whose date has passed [not sure if =IF statements using...

Hello All, Below is a formula I found on the website and I've been trying to modify it and make it work for what I need but to no avail. Here's what I'm trying to do: In column B is a list of last names, however, some of the cells are empty. For those cells that are empty but the row still...

<o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"></o:smarttagtype><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"></o:smarttagtype><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom>...

Hi all, I am using the "Move rows" macro from #973. We constantly have people leaving the company (some for good and some on assignments) and many new people arrive monthly. I use the macro in two ways: 1. When someone goes on assignment I move their details with the press of a macro button...

Hi In A1 I have a project code, and in B1 I have the Project Name. In the subsequent rows, I have 5 cells that I need to move up next to the project code and name. This format is throughout the spreadsheet, however the number of rows following the project details varies. Folowing each...

Hi all, i have this at the moment: in a sheet named CURRENT is all our data. when the jobs done the Satus Column "F" is changed to INVOICE and then once a day or whenever they are all moved to a new sheet named the month and year, in this case JUN 09 this works fine as it is but at the moment i...

I created a spreadsheet that tracks modifications made to hospital accounts. Once an account has been corrected, the user clicks a command button and cell U in the active row fills with the current date and time ((now)) according to a macro I created. After 5 business days of this cell being...