cut and paste

  1. F

    Cut and paste rows issue - for images

    I have issues when cutting and pasting entire rows, where the rows contain images. Sometimes it works, most of the time the images get left behind. Is there a setting which can fix this?
  2. C

    Macro for command button to copy + paste on each click next row from table to another table

    Hey everyone, hope you are all fine. I have 2 Tables: MasterTable UsadasTable I need, on each click on command button, to cut values on MasterTable B4/C4/D4 and paste to UsadasTable I4/J4/K4 On the next click, i need cut the values of the next row from MasterTable B5/C5/C5 and paste to...
  3. F

    Cut and paste rows with image

    Often when cutting and pasting rows with an image inside the range, the image stays where it is rather than moving with the rows. Has anyone come across this? Couldn't find anything on doing a web search.
  4. B


    Hi guys! I'm wondering how to build a macro for the following repetitive tasks: 1. Selecting a specific cell, 2. Goes to the last row with data, 3. Selects all the row, since the 3rd column until the end, 4. Cut all these cells 5. Pasts on the column A of the first blank row below the...
  5. T

    Cutting and Pasting individual cells that meet criteria to same row of different column

    I'm a n00b and I've been searching the forums and the closest thing I can find to my problem was addressed here: Simple Macro to cut and paste based on cell value I'm trying to have any cells in column M that are greater than 0 be cut and paste into a column 3 columns to the right of the...
  6. tourless

    find and move

    Hi Folks. I'm working on automating a solution to a problem file and I need to extract some rows to a new sheet programmatically. Specifically I'm looking for a way to loop through column H and any cells that begin with the word 'Net' (spelled exactly like that) need to be cut out and moved to...
  7. D

    Cut rows after cell value and insert above cell value

    Im dealing with a slightly screwed up software export, what im trying to do right now is: cut all rows with content below my case ("Total Ertrag") until the next empty row (cut without the empty row) and paste it above my case im having a hard time getting a clue as to how i should go about...
  8. B

    2 macros - Copy Row and Cut and paste row to another worksheet based on value

    Afternoon all I've been working on a spreadsheet. I had no VBA knowledge at all, now I still have close to none! I've been searching various forums and websites and copied and pasted code in a trial and error way, sometimes successfully, sometimes not. I'm stuck now though. I've seen lots of...
  9. M

    If value in column B = 1, then copy and paste content of Column A to another sheet.

    Hi all. I am little new to Excel coding and would really appreciate some help. I am writing an excel sheet for my students but getting stuck, essentially they will fill out a sheet scoring themselves from 1 to 5 in certain areas, Col A will have 50 skills, they will rate themselves 1 to 5 in...
  10. S

    Code to cut data and paste as values, then delete specific range of row when the cells in column D is blank

    Hi I am a new VBA learner. Need help for code, to cut data and paste as values, then delete specific range of row when the cells in column D is blank Eg. I have a quotation table in my sheet (=Quote!$A$10:$AL$265). I would like to first cut of (=Quote!$A$10:$K$260) and paste as value...
  11. K

    Extract/Move row based condition

    Hello Everyone, I have searched this forum and others for several days but can't find what I needed so I took a stab and trying to code myself and it was an epic fail.... I have two workbooks wb1 (has master data in it) and wb2 (storage data). Here's what I'm trying to do... -If column AA in...
  12. D

    I need help writing a Daily Average Formula

    Howdy, I have a problem that I can't figure out, and I'm hoping someone here can give me a hand. For the past several years I have been keeping a record of how far I walk/run/cycle each day via Excel. It has worked great for letting me see my average year by year. However, I have one Excel...
  13. T

    Shifting a selected range of cells to the right or left

    I have a spreadsheet that needs to shift a selected range of cells one column to the right or left using an "Advance" or "Delay" button. Here is the sequence of operation: 1. Activate a button 2. Select the cells beginning 2 spaces from the button's originating cell to 10 spaces from the...
  14. Roderick_E

    Easy Cut & Paste to duplicate sheet

    My company uses a lot of spreadsheets where there are 2 tabs; one for "active" and another for "completed". The user typically will cut and paste a completed row from the active sheet to the completed sheet. Both sheets have exact same headers. To automate this, I created code so that the user...
  15. D

    Find Text, Cut & Paste It In Another Column

    Hello, I'm using Excel 2013. I want to find a particular text, cut & paste it in a column of my choice within the same row. This text may be present in any column. I have gone as far as the code below which works fine. However, the code stops half way though there is more rows to be searched...
  16. Carlo22

    Cut and paste values only? to avoid copy>paste values> select initial cells>clear cells

    Hi, I'm looking for a way to easily move only values from one cell selection to another. The formating of both the source and the destination cells are to remain the same. So far I couldn't manage to find a solution in this forum or elsewhere. Does someone here have a solution? Thanks!
  17. M

    Text not going in to cell correctly

    This is probably really easily soluble as it seems a very stupid question. When I cut and paste text into some cells the text goes into the cell, fits in at the width that I've already selected for the cell and expands the cell downwards so it all fits. However sometimes, the text appears on one...
  18. S

    Macro: Coding Macro to Select, Cut and Paste Row from one sheet to another (Excel 2010)

    Hello! I am needing to code a macro that can select a row of information, cut it and then paste it into a different (already labeled) sheet. To elaborate I would like to select cut the information from "Sheet 1" and then paste it into "Sheet 2" in an identical format without pasting over any...
  19. A

    Search ".xls" files and then CUT and PASTE to new location

    I have a folder with many subfolders and I want to search ".xls" files from these subfolders and then cut and paste them to new location. There is a code available over interned for searching files in folder but apparently it does not work in newer versions of Excel.
  20. A

    Copy and Paste work but not Cut and Paste in vba

    Hi, I am new to vba programming. I have written the following codes. The codes work for Copy and paste, but when I change to Cut and paste, it won't work. I am trying to cut a row on one spreadsheet, and paste the row in another spreadsheet. I can't figure this out. Can someone help me? Thanks...

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