move rows

  1. M

    Moving rows from one sheet/table to multiple sheets/tables

    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...
  2. E

    Automatically move rows to another worksheet

    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...
  3. F

    Moving a row upwards

    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...
  4. S

    Move Rows To a Specific Worksheet Based on Entry in a Cell

    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...
  5. S

    Move Data across worksheets based on cell input

    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...
  6. A

    VBA code to move entire rows from one sheet to 3 different sheets based on cell values from dropdown list

    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...
  7. N

    Move rows to other sheets using a command button

    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...
  8. J

    Move rows into another worksheet/workbook based on cell criteria

    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...
  9. M

    Move rows to another sheet based on criteria and rename sheet based on data

    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...
  10. D

    Macro to use everyday that moves rows from one sheet to another

    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...
  11. H

    VBA if/and statement move rows

    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...
  12. S

    Autofill cell based on other cell data

    <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>...
  13. M

    Moving rows

    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...
  14. S

    Move cells using macros

    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...
  15. A

    Move INVOICE to other worksheet

    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...
  16. B

    Move 'old' rows to different workbook

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top