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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top