move column

  1. G

    Rearrange column headers using listbox

    I'm looking for a way to move line items in a listbox to rearrange the order of my table headers. So maybe a click and drag approach where I click and hold one line item in my listbox and drag it to a different position in the listbox so that it changes the table header location. Or maybe...
  2. M

    How to move a column from a sheet to another depending if the last row contain of a column contains a specific value?

    Hello All, I am actually working on a reporting file. I wish to have a VBA code which moves the columns from sheet1 to sheet2 if the last cell of the column contains a specific word. Can someone help me please? For example the values are from column B, first row is 3 and last row is 84 and if...
  3. K

    Move column from one worksheet to another based on active cell

    I have the following code that moves a row to the next blank row on a different worksheet based on the active cell that works great. Sub Shipped() ' ' Shipped Macro ' Move selected data to Opened Worksheet Dim rngsource As String Dim Rngtarget As Range Dim trow As Integer Dim Srow As Integer...
  4. F

    Moving selection using offset

    Example: I have selected columns (B10:B15). Now I want to move all content to C11:C16 (1 cell right, 1 cell down). I now how to cut the section. Dim wbp As Workbook Dim ws1 As Worksheet Set wbp = ActiveWorkbook Set ws1 = wbp.Worksheets("test") Selection.Cut How to paste to destination using...
  5. E

    Macro for moving data from worksheet to another but to the right dates

    Hello forum members, I have a simple problem but I really really really need your assistance. Before posting this new thread I have done extensive search on google for 'move column' 'move data' and couldn't find what I was looking for. I have a workbook with 2 worksheets "Data" and "Ledger"...
  6. L

    Move column in Excel 2007, extremely slow HELP!

    I'm using Excel 2007 (operating system is Windows 7). Since changing my VBA program from Excel 2003 to Excel 2007, moving a column is extremely slow. I have a program that has to move 5 columns in a specific order, and it's taking 10+ minutes. I have 4000 rows of data I originally selected the...
  7. N

    VBA Find - Move macro

    Hello, I have an Excel file that has columns in random order. The order I would like to have them in is listed under 'MyArr.' The problem is that not all of the column names which are listed in 'MyArr' are in the file. They are also in random order. The macro below seems to be a good...
  8. Cell Block

    Need help altering macro to move columns not rows

    Hi all :), I have a currently working macro for an employee list workbook that I need to alter for a newer version of the same. Currently, there are two worksheets, Active & Inactive. Column headings are in row 2, starting with column A and ending at column I, Employment Status, Name, Hire...
  9. S

    Move cells using macros

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top