insert row below

Hello there! I'm an enthusiastic if incredibly amateur Excel user- I usually just use google to figure things out but I'm hitting walls with this issue, so thank you in advance for any support or help you can offer! I'm trying to build a feature into an Excel sheet, so that if you click on a...

Hello everyone, I'm trying to automate specific tasks for our business and decided to rework our excel files. These excel files are used to upload specific products automatically. The base idea is to insert new rows with predefined values with checkboxes. I've already written some code which...

HI Sorry I'm not familiar with VBA but I need this for my project I need to create VBA button with a code to insert a row under a random selected cell "let's say D" and then merge each of the cellS before it ",C,B,A" with it the new cell inserted under it; for example C2 with C3, B2 with B3...

I have an array of data that has 28K rows in it. This array is for Production BOM's. The data has columns of Production BOM (C), Description (D), Component (E), Description (F), Supplier Name (G), Supplier Part No. (H), Quantity per (I), Unit Of Measure (J), Supplier Number (K) What I need to...

Hello all First of all I need to say thank you to all of you that have helped me and write (tried and did) the below code. The code is working perfectly. What the code do is that it collect data from 3 or more sheets and insert them to another sheet in order to create an invoice. So far , so...

I have data in sheet1 in Column A I have values from 1 to 10000. I want that after every 10th row a new row/cell will be inserted and in column A against the new cell text "NEXT" will be added. What should be the code for this ?? kindly help

Hi all, I was hoping someone might be able to assist with the following as I am a bit of an Excel macro novice. I am trying to create a spreadsheet where users fill out the details in grey to create a budget. I have protected the sheet so users can only edit the cells in grey. To make this...

Hello Excel wizards. I need a multi-faceted vba code that automatically runs when a drop-down text option is selected. I need the VBA to change the drop-down text to another text option in the original row and then add another row and pre-populate the drop-down cell text in that new row. For...

Hello I have multiple rows for a weekly update and I'd like to have 2 cells that the user would populate with a date from last week and the other would be a date the new update would be made. I want to look at column J and if it has a the date in the user entry cell (Previous week date) then...

Good day, I need VBA code to automatically insert a row below or inbetween rows based on criteria. In the example below, I need code to run row by row to check if the "OVER" column >0, if that case is true, it will check 3 conditions: 1) Check the "HOURS" column for the max hours such as 10.5...

Hi All, I found the following code but want to modify it slightly but not sure where I am going wrong. I basically just want the following to happen 1. Input box asking on what row should the insert start 2. How many rows to be inserted Click ok The code below has a bit about intervals, I...

In my Excel sheet I have values from Column A to Q. Column A is the Serial number Such as 1 2 3.....starting values from A6 as 1. Column G is filled in without having Blank rows. Example Column A6 is 1 & Again column A8 is 2. Hence I want to insert a Row in 8th row & will have a Text TOTAL in...

I have a spreadsheet with multiple sheets. I am trying to set it up so if sheet 2 D30 has a value, a row auto inserts on sheet 1 line 4. I have been looking for a while and can't find anything that does what I need. Any help would be greatly appreciated.