add column

  1. D

    Power Query - COM-Error due to month & year extraction from date

    Hello everyone. For some reason, I keep getting an error, when I try to add two columns (year and month) based on the value in a "date" column. The error appears once I try to establish a "Data-connection" and add the data to my Data Model. I apologise for the language below being in Danish...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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 =...
  16. 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...
  17. 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...
  18. 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...

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