cutting

  1. B

    Cut and paste in Excel

    Hi, I have a problem: I need to line the same people in column B and currently it looks like this person is always in one cell from A-H but not always in column B as desired. If this person is in for example column H then I have to move him/her to column B and person from column G to column A...
  2. A

    Copy data from selection of sheets

    Hi I'm trying to collate the data from sheets 2 through 11 onto sheet 1 of a workbook but I'm struggling with the macro. How would I go about cutting and pasting the rows with data from sheets 2 to 11 (without headers) on to the next available row on sheet 1?
  3. O

    How to add an external Reference to an exported excel report

    I am using a Spreadsheet as a form. Currently my people are printing out the form and hand writing the data in to the cells. I was wanting to speed things up. We have 2 exported reports that could be used to fill in the data fields and ranges. Currently I've been cutting and pasting the data...
  4. B

    Code showing sheet 1 and 2 when executed problem

    Thanks for looking at my post. I have had issues with this for sometime and I really cant pinpoint when exactly it happens. I do know that it sometimes happens when running the code below. When switching form sht to sht as shown below it will show a partial view of the other sheet. You can...
  5. T

    Cutting and Pasting using a Command Button

    Hi There, I have read a couple of forums on this but am still not getting it right. Lets say I have 2 worksheets. Sheet 1 and Sheet 2. I would like to have my command button do the following: 1. Cut the selected cell from my existing worksheet (this I have achieved albeit through assistance...
  6. H

    Multiple Cells Cut and Paste

    Hi, Is there a way to code for cutting and pasting multiple cells that are not joined. So cutting E8, F3, G13 in sheet 1 and D1, H5 in sheet 2 and pasting to A3, B4, C7, E1, J10 in sheet 3? I have coded to do it individually, but i'm getting inconsistent results. I don't know if going back...
  7. L

    Cutting and Pasting values in a range of cells, with losing cell formatting?

    I have a worksheet with many separate users. There are large ranges of cells being cut/copied/pasted frequently within the spreadsheet. The data is separated out into a nice clean grid using borders on the cell formatting. the issue is that when cutting and pasting the cell formatting of the...
  8. W

    Issue with cutting and pasting excel chart with data table next to chart

    I'm having trouble cutting and pasting an excel chart with the table of data next to it. I'm pasting as picture with an expectation to get a result that is exactly what it looks like on the excel sheet. Also, this has not been an issue up until very recently, and the issue follows all excel...

This Week's Hot Topics

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
Top