move cells

I imported a very large flat file dump (187K line) and want to move ranges of cells to a new worksheet if a cell in the range contains a specific sub-string. These strings can appear multiple times in the file dump as well as multiple times within a range/block. So whenever the string appears in...

Hi guys, I am trying to move cells on the Product ID cells. <tbody> HEIN4 MC Product ID Prdouct Group 426 3 59 3 68 3 78 3 72 3 </tbody> Here is the example of data and I would like to move HEIN4 move down 5 and go left 2. Then Move MC 3 down and...

Hi, I am trying to create a macro that will select data cut it and paste it one cell up and one cell to the right. To select the data i am using a filter, i do not know if there is a better way please help here is what i have so far The offset gives me the error compile error argument not...

I have a lot of data in cells but I am really only interested in certain cells. I want to extract the cell in each row which contains a "-" (there is one in each row) and move them into a column of their own. The entries containing the "-" are not adjacent which makes it tricky to move all of...

Hello, I have approximately 350000 rows of the following data in one column: >data1 result1 >data2 result2 >data3 result3 The data does actually start with ">". I would like this to look like in two columns: >data1 result1 >data2 result2 >data3 result3 etc 350000 rows is apparently a...

Hello, Here's a task I want to automate. This is a macro I did with the macro recorder to move the contents of a cell to the cell next to it. movemacro Selection.Cut Destination:=ActiveCell.Offset(0,1).Range("A1") ActiveCell.Offset(0,1).Range("A1").Select Now, using Ctrl select to select...

Hi In A1 I have a project code, and in B1 I have the Project Name. In the subsequent rows, I have 5 cells that I need to move up next to the project code and name. This format is throughout the spreadsheet, however the number of rows following the project details varies. Folowing each...