move row

  1. C

    Move every 2nd row to the end of previous row

    App 2500 rows of data. Yellow A2,B2,C2,D2 must be moved to grey E1,F1,G1,H1. Do I type the instructution/formula behind fx Thank you very much and regards ...peter
  2. E

    move row to sheet based on UserForm ComboBox value

    Hi guys, I am looking for VBA code to look in column A for a certain = ComboBox value and when finds to check row number, move it from sheet1 to sheet2
  3. M

    run-time error 1004 : Application-defined or object-defined error

    Hi Excel folks, I m trying to move every second row at the end of previous row. This below code is being applied from the third row. I m getting the desired out , but i m also getting the below error. " run-time error 1004 : Application-defined or object-defined error". I m aware that...
  4. S

    Show row info if

    I am producing a sales pipeline spreadsheet for an estate agent I work for. I have created an input sheet for data entry and clean sheet of the data for printing and presentation. the data iin a row is i formation like property address, sold price, exchange date, fee's etc. I have a table with...
  5. Y

    Move Row with a specific text in a cell to different worksheet.

    Hi to everyone, I use to check this forum a lot as a quest, but now I need your help because I am 0 in macros. I have a task management file, where we assign task to a team consisting of 4 people, with specific deadlines. I want that when I will mark the status of a task as `done` and after...
  6. W

    Move row to sheets based on condition

    I'm having trouble with a macro to move rows from one worksheet to another based on a cell value. I have a row with 4 headings. The final of these 4 columns will have one of three outcomes, CHANGE, NOTCHANGED or blank. If the row is blank, the script should ignore and check the next row. If...
  7. S

    Move data to new sheet if more than duplicate in one column

    I have a spreadsheet with multi columns of data there are dups and triplicates I want to keep all the data that is dups but move if more than two instances. I'm looking to do this vai VBA EX. (Note there are up to column K) Column A Column B 1234 address info 1234 address info...
  8. S

    Moving a row of data automatically based on a specific criteria from sheet1 to sheet2, macro, vba or vlookup?

    HI, I hope I'm doing this correctly, as it's my 1st post. Great info here, I'm relatively new to Excel, but i know it does what I want, it's just getting to that point I'm trying to move a row (horizontal) from sheet1 to sheet2 automatically based on there being content in column b...
  9. B

    Need Macro for a Command Button to Move Row to Another Sheet

    I am in need of a macro for a command button that when clicked any row within sheet1 (Hold List) with a value in column N (Item Number) would be cut and pasted (entire row) the into my second sheet (Items to be Received). I would greatly appreciate any help with this. Thank you!!
  10. J

    Macro: Move active row to top of VISIBLE rows?

    Rows 2-XXXXX are all hidden. The row number of the last hidden row increases occasionally. I need a macro that will move the row of currently active cell, to the top of the VISIBLE (unhidden) rows. For instance, if rows 2-1500 are hidden and the cursor is on cell D1600, when the macro is run...
  11. K

    Excel database (list): button to move a record (row) to next sheet which is a similar list (several problems)

    I use Excel to keep track over clients, and the sheets include lists, so that I can easily hide and show the records I need. (I used this tutorial to make the lists: http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database_6.htm) (Unfortunately the document is on a secure zone...
  12. K

    Basic if , then , move help please

    Hi, I need a code to do the following IF A CELL IN COLUMN H=INACTIVE THEN MOVE THE COROSPONDING ROW TO TO SHEET2. PLEASE HELP, I HAVEN'T USED EXCEL IN SO LONG I AM LOST, I HAVE TRIED GOOGLING BUT CANT FIND THE COMMANDS

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