add column

  1. C

    VBA Help - Add Column, Formula to subtract surrounding columns

    Hey all, I've always had wonderful luck on this website with the wealth of knowledge available here. My spreadsheet contains columns that contain the current weekly inventory. This adds a column every week, making the table dynamic and ever-expanding. Example of last two columns: | Pint...
  2. M

    Add columns and delete columns based on the another workbook in VBA

    I have workbook A with sheet1 contains like below header ID Class Mark Grade XX AA BB CC XX AA BB CC XX AA BB CC XX AA BB CC In the another workbook B contains like below but ID Class Mark Attended XX...
  3. G

    Adding a new column to end of a named range

    I have a named range on sheet Competitor Comparison Data called “CCData”. I would like to add a new column to the end of the table every time I press a button. With each button press, a new column is added to the end of the range and is then included in the named range. The new column should...
  4. G

    Assigning a formula to a button

    Hi, I would like to be able to assign a command button to add anew column to the end of my table. Each new column added should appear to theright of the last new column added. The command button will be on theactivesheet but the table in which I am trying to add columns to will be onsheet...
  5. G

    Button to add column to the end of a table

    Hi, I would like to be able to assign a command button to add a new column to the end of my table. Each new column added should appear to the right of the last new column add. The command button will be on the activesheet but the table in which I am trying to add columns to will be on sheet...
  6. P

    VBA adding column then adding Left formula

    HI am new to VBA and trying to create a Marco to add columns to E and L, which i have a as Range("E1").EntireColumn.Insert Range("L1").EntireColumn.Insert but then i want to add a formula to E and L of =Left(D5,5) and =left(k5,5) going down to the last row. but if in row 6 it will be D6 and...
  7. T

    Macro to add new column to a table, rename header, add formula to first blank cell, then refresh

    Hi all, Obligatory "new to VBA"... I'm trying to create a macro for my boss that would allow him to 1) Add a column to the far right of a table in any workbook 2) Name that column "Day of the week" 3) Find a column in the table with the header "Adj Order Date" and apply a formula in the...
  8. C

    Expression error when add column/invoke custom function...can't convert the value

    I successfully created a workbook that had a combined sheet (that contained 7 other workbooks) that successfully used several formulas/functions to get 5 Fiscal Years totals and then produced slicers. I wanted a way to allow the 7 managers to update their individual workbooks an then automate...
  9. E

    Add Columns without Data but keeping formulas

    Hello, What is the VBA code of a button where once clicked, asks me how many columns I want to add after my last columns in my table, but they should be empty without any data but all formulas/conditional formatting/background colors or else should stay the same. Thanks for helping asap.
  10. F

    Update daily sales data

    I have problem updating my company's sales data. The ERP does not allow me to pull daily sales data and I have to calculate it manually everyday. I need to insert a new column daily. Is there a better way to update the sales data so that I can compare to the inventory data and make purchase...
  11. P

    Pivot table added column in external source

    Hi all, I have created a pivot table from external data source (xlsx table). Refresh with new records worked fine until I added one column to the external source. Now excel freezes when I refresh. When I inserted one column in the internal data source the pivot table would only add a new data...
  12. C

    How to Highlight an Additional Column without Referencing Specific Cells

    I'm attempting to highlight an array plus an additional, empty (or partially empty) column to the right of the highlighted array. I'm using "Range(Selection, Selection.End(xlToRight)).Select" to highlight the data. <TBODY> A B C 1 Data Data No Data 2 Data Data No Data 3 No...
  13. P

    Need help AutoFilling a formula in a column

    Hello, I'm pulling data from a CSV file. The CSV file has a "Quantity" column that contains the absolute value of the quantity. I want to add a new "Qty" column and an if statement to say if certain criteria is met, make the value negative. Here's what I have so far from the recorder...
  14. B

    helping scaling down small code...

    If anyone has any recommendations that might make this a little smaller, I would appreciate it. Its not that slow or long but every little bit will helps. Application.ScreenUpdating = False Sheets("Test Sheet").Select Range("Ash3Freq").Value = ComboBox1.Value Range("Ash3Trgt").Value =...
  15. S

    Add Column to Excel Table (VBA) but only 1st row populates not entire row

    I have an Excel spreadsheet with Macros/VBA: * runs several SQL queries from an external database * populates worksheet(s) with SQL result(s) * in each worksheet, select data & create a table * add extra columns to most of these tables * add calculated formulas to first row of these extra...
  16. A

    Add New Column

    Hi All, I have a requirement where I have to format a given spreadsheet which has multiple columns(almost 20 ) and 400-500 rows to have 3 columns only of which 2 columns come from the base spreadsheet and the 3rd column is Date column for which I have to prompt user. I have the macro for to...
  17. P

    Macro to insert row/column and copy the formula from the preceding row/column

    Hi, I have quite a complex macro question to ask (at least in my mind anyway :rofl:), but seeing as though people on here like a challenge i thought i'd post it: First of all see screenshot of my spreadsheet for reference: What i am trying to do is to create separate macros to do the...

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