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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top