add column

I am using Power Query to combine CSV files from a folder. Each file has 2 "junk" rows which are removed at the Transform Sample FIle before the files are all combined. However I would like to grab the "As of" date/time from those rows and fill a new column with that info prior to removing...

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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