cutting

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

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?

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

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

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

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

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

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