cut & paste

Hi, can someone please help me with a macro. In column AP I have a series of numbers and blank rows. I am looking for a macro that will loop through column AP starting in cell AP2. The macro would skip blank rows and cut and paste the numbers it found into column AQ but would also offset down...

Hi, I'm struggling with Macros abit and I am wondering if any of you people could help me? I have 2 worksheets "Sheet1" & "Sheet2" I have done a small table below just as an example. Worksheet one is the sheet that I fill in.. I need a Macro that automatically transfers a whole row once any...

Hi, I have two columns with text. some of the rows has a (text) in front of the text, is there a way to move this (text) to the end of the text of the other column? <tbody> A B (1)One One (car) Red Red (above)blue Something </tbody> The result I need is: <tbody> A B One One (1)...

Hello everyone! I am trying to create a button which cuts cells Bx to Fx if the cell Fx contains the word "outlier" and paste it to a different part of excel sheet. My code seems to work up to the "Cut" part but stops at the paste. It has an error on "ActiveSheet.Paste" part of the code. Please...

I'm currently sorting through a data set where I'm not trying to eliminate duplicates, but cut and paste them to the same row as the original value. Is there a formula for this? The data set that I'm sorting through is AG1 through AG4404, where columns AG through AU are linked together.

Hello guys I want to keep my cells merged even when i cut and paste them, is it possible ?

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

I have daily repetive tasks that need a VBA to help me out. I have a file which is updated daily, the excel file contains like: First Name|Last Name|Email| Password John| Lee | Johnlee#hotmail.com | blabla ...... So here are my tasks, when a client ask for like 100 accounts, I cut 100 accounts...

Hi, I get this data from a source which is not captured in order, cell values gets jumped to next adjacent cell. Refer the "AS IS" tab. I would like to copy the cell values from J (row 2), L(row 5) and P (row 6) to column H. Once cell values copied delete the blank columns. "TO BE" tab shows how...

I am attempting to create a Macro that allows me to cut a cell from column A and place in column B. For example I need a item cut from Cell A162 and pasted in Cell B161. I need the same Macro to cut cell A165 and pasted in Cell B164 ect... This will need to continue until cell A1374 is cut and...

Hi All, I am stuck on something and I am hoping that someone can help me out. I want to be able to select the cell where this macro will start. IE: Change the Range("C1").select to a user select by clicking a cell? I am not sure how to go about it. What this macro does is it selects a range of...

Hi, I need some help with the syntax here; my code is trying to cut a range of cells and past them onto a new sheet created by vba, when I use range.copy it workd perfeclt fine but when I do range.cut which is what I want I get the error 1004 application defined or object defined error. Here is...

Hi guys, Sorry but I have know knowledge at all about VB In order to create a bi-lingual glossary, I'm in need of a function which must: 1. cut from column 1 and paste in column 2, the word(s) contained between the sign "=" exclusively and the sign "(" also exclusively; 2. cut also from...

Hi, Should be a pretty simple code, but I am not very experienced with VBA. I have a list of stock holdings with various data (cost, ticker, etc.) in B1:K50, which is sorted alphabetically. I want them to stay alphabetical based on Column b (stock name), but I would like to cut and paste the...

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.

1 Workbook 2 Spreadsheets - "Complete Backlog" & "Closed Jobs" If Column K in "Complete Backlog" says "Closed" then cut that row and paste it into the next available row of "Closed Jobs". I have this code below but there is an error with it. It currently cuts all of the items marked closed but...

I'm using 2003 (company computer :( ). I need the macros to manipulate cells not entire rows So here's the algorithm: If a cell in Column K of the "Complete Backlog" spreadhseet is equal to "Closed" then cut cells A?:K? of the same row and paste into the next available row of the spreadsheet...

Hello, I was hoping someone else has/is experiencing this same issue as me, but have been unable to find a situation that matches it exactly. The problem is that whenever I have any browser open, IE, Chrome, Firefox, etc... the Cut & Paste, Copy & Paste function does not work correctly in...