insert column

I need to insert new dates as I add new dates I need to calculate the 4 wk, 8 wk, & 13 wk. For example, if I inserted 2/10/2024, I would need the formula to take into account the new date and provide the 4 wk, 8 wk, & 13 wk average. I used this formula: =ROUND(AVERAGE(OFFSET(D4, 0...

Hello! I have a code that is almost working, but I need some help getting the last bit. I am essentially trying to ensure that I have a consistent set of columns, in a specified order. Sometimes when we export a report from our financial tool, it doesn't give us all the columns we need, so this...

Hi Guys, I want to insert the column (in loop) for another sheet. The example below is the code for inserting column in the current sheet only. However, does anyone know how can I insert the column in Sheet 2 from the code below please ? Example: Sub VBAColumn4() Dim Column As Integer...

Hi All, Im trying to incorporate an add new row and column funtion in my spreadsheet How can i get the following bits of code to work independantly of each other? The first part of the code works fine and adds a new row exactly where i want it but im struggling to get the second add column...

A bit of a novice here. I usually try to find my answers first before posting, although I kinda found an answer on a thread here, when asking for help I was told to start a new thread. So... I have a sheet with 5 columns (C-G). I need to insert 5 columns with the same formatting and formulas...

Hello, any ideas how I can get the following code to work? I am adding a column called "Value less VAT", then adding in the formula in row 2, then attempting to drag it down to the last row. Everything works like a charm, except the dragging down portion. See details below. Code #1 = my code...

I more or less need some input on if this code could be more efficient. If it can be faster please let me know how. All input is much appreciated, even if it is as simply as it's good as is. Dim MyTest As Range, AshF As Range, AshT As Range Dim AshH As Range, AshL As Range, myRng As Range...

I am working on an inventory project and have 2 problems that i cannot find a solution for. 1. The first is i need to select the first empty cell in the first row and fill it with the current date. I have the code for the date working great and the code works fine the first time, but after...

The following code works as desired, but will be SLOW when there are more columns present (the elements are merely examples - my actual worksheets have 40+ columns and can have hundreds of rows). I feel like this could be an array formula, but I'm just learning about those. Could someone help...

I should mention first, i'm new to the VBA and trying to learn, please excuse any of my rookie mistakes, and I greatly appreciate all of the help/input anyone is able to provide. I have a report that we run daily. It involves pasting data from a database, removing rows with no Call...

Hi, I have a 100+ column spreadsheet. For each column, I have to insert a new column (starting at column "C" to the last column) and fill it with text from the first cell of the column to the right. I use this code to make it work, but I have to copy it 100+ times for each column insert. Is...

I have a worksheet where I must insert a column every time the user selects 2 values (found in Pricelists sheet). So Basically whenever a user chooses the Quote LP, or the Sell on web Values from the cell dropdown, I must insert a column adjacent to the value. (The dropdown values are referred...

I have an Excel spreadsheet that where the headings start in row 5. Data starts in row 6. The spreadsheet is updated frequently. The headings are always the same but the number of lines of data changes. D5 = Units1 (field contains numbers or is blank) E5 = Units2 (Field contains numbers or is...

Hello everyone , i am very new to this . i Was wondering if anyone can help me i have a two step problem The first part of it is that i would like to be insert a new Row between each row on my Excel sheet that has data so if i have had Kilometres Time 1 10 3...

Hi all, It is the very first time I work with VBA and I am struggling quite a bit. I have an Excel sheet in wich I have to insert a number of columns equal to a value in a cell. Note that the value in this cell will change over time. As a result, it is always the same cell that I would like to...

Hi, I have got an excel spreadsheet that I have some rows protected in (utilising a macro). Because of the protected rows I can no longer insert new columns as the option is greyed out (because I have protected it against selecting some of the rows) when I right click a column header. Is there...

Hello, I realize that this is probably a topic that has been discussed before, but I couldn't find an answer that worked for me from prior topics. I have an excel spreadsheet with a large amount of employee data. About 150 employees are listed across the columns along the top, with four...

Hi. I posted this a little while ago with no luck. Any new takers?? I need a macro for inserting a column at a prescribed location (i.e. this will vary according to what the user wants). This column needs to have the same formulas as the column to the left. I would like a dialogue box to come...

Hello, I'm trying to insert a number of column in the middle of worksheet. The number of columns are dynamic based on the date range in another tab. I need to take the total number of columns in that tab and dynamically change the number of columns i add in based on whether a toggle choice is...