cut

Hi I selected cells and I want to cut them and then paste them somewhere else. So I wrote the code below. The cut part is working but not the paste. Is that the way it should be done or there is better way? I am learning how to use Selection object. Any idea would be very much appreciated. Sub...

I would like to cut from Sheet1 (A1:G100) all rows which have "Archive" in column G. The results would be appended to the next empty row in Sheet4. The remaining rows in Sheet1 in Range A1:G100 would shift up without affecting the existing conditional formatting rules that are applied to that...

Hi all, You've all been so helpful in the past, so I thought you might be able to help me out once again. I'm trying to work out lead times based on a cut off date, I need to subtract the lead time (Column B) from the cut off (Column C) to calcualte the last order date (Column D), however I...

Hi All what is the best way to find a specific value called Leaver in say range (A2:A50) and cut the entire row when found and paste it to the bottom deleting and blank cells in between? my aim is to ensure that i have all leavers at the bottom of the data

Hi All, I need a script to look down cell "D" and if it is empty then cut that row and paste at the bottom of the sheet. Thanks

Hi, i want to prevent the user from doing Cut and Paste but to allow him to preform Copy and paste ( when they are doing Cut and Paste their getting Ref# error in formulas) when i use this code it prevents also the Copy and Paste which is needed by user and it doesn't do the Ref error...

I currently have the code below written to allow a custom button on the right click menu. This was written to allow a user to cut and paste a row to a designated spot within a protected sheet. My question is, how do I get this code to allow the user to highlight multiple rows so they can cut...

Hi Everyone, I have a document that we use as an input document. All people have to do is Type in the amounts etc into the correct cells. everything is protected and setup nicely so you would think this is fine, but NO. Some people insist on breaking it! the latest way is with cutting and...

I have a series of Dynamic cells with If(something="","",do something else). My problem is that counta or xldown etc, see the empty cells as having data. Is there a way to have them seen as being empty. I do want to cut paste elsewhere if that helps. Thanks.

This was raised to me in IT because one user is getting rather annoyed at it. So I have an issue with excel in our company, where when you open any excel document, doesn't matter if its created by you or someone else, or even if its new or old. Each time you click on a row (Row No. 60) then...

Hi! I would really appreciate help in building a code that would : In Sheet 1, if any cells in Column E contains the word "Done" it would cut Column C of that row to the last column with data in the same row Paste the entire row that was cut as values into the next free row in Sheet 2 Then...

I have a pivot that has a field with very long text. The text is all there in the pivot however when I do a VLOOKUP against the Pivot, that field's data keeps getting cut off. Any idea how I fix this so that the full text shows up?

Hello, bit of a VBA newbie here coming for some (hopeful!) guidance. Below you will find my code for an ongoing project I am working through. My goal with this macro is to update the master sheet off a generated report that is sent to me using Vlookup. If the lookup value is found on the...

I remember seeing on a You Tube video where the user used short cut keys to bring up a list of defined names when he was creating a list in Data Validations. Does anyone know what that short cut was?

I have some skus, and I need a formula that will cut off part of it. Here are some examples: KIDZ-1960-1-SPCP GUIDE-G6713 EC4R(1a)-ELR-15651-BK Those are examples of different kinds. I need JUST the letters before the first hyphen, but I also need it to cut off if there's a parenthesis. So for...

Hi I'm after a bit of help with a sheet. I'm making a costing spreadsheet. Essentially the way it works is that a customer gives me a spec of a piece of material that they need. E.g. Material X, 80mm x 60mm x 1.2 thick. I have in stock, sheets of various materials in various thicknesses and...

Hello everybody. I'm dealing with a big amount of datas, about 40k rows. I need to cut and paste entire rows from a sheet to another, if conditions are not checked. Example: cut and copy in the sheet Beta if in column A of sheet Alpha <> 36 characters Assuming - but I'm not sure - that the...

I'm hoping I make this clear. I'm using Excel 2007 and several years ago, all of a sudden, it took just one of my macros (located in Module 1) and renamed it Module1.FBPlus in some of my files. It was just FBPlus. It did not make the change in some of the files. When I try to run the macro...

Hi guys, I'm having trouble with a cut and paste macro. I used the macro recorder to cut a line from a worksheet and paste it onto another worksheet in the same workbook. I then have the macro attached to a checkbox. the problem is that when I run the macro it pastes the data onto the second...

My question is pretty basic. How do I do a vloopup in any column. I only know how to do a vlookup when both spreadsheets have the first column the same and matches. I have seen people pull a vlookup without having the first column match. I usually cut and move the same columns in each...