insert row

Hi I am looking to format a data dump into a pivot table friendly format for which I need a macro. My skills are very basic so I would appreciate your help a lot! The problem is that we have always 4 different Products including Quantity and Revenues in column K to R and not in database format...

Hi there, I'm working on finding out missing orders in a bunch of sales records. I'm attaching a sample workbook here so that you can understand more of my requirements. Appreciate all the help you can provide. The sales invoice denotes the sales invoice number at a material level. The item...

Hello, I have two sheets: Sheet1 and Sheet2. In Sheet1 I have names (Name1, Name2, Name3...) and projects (Project1, Project2...). I mark with an x the name assigned to a project. In Sheet2 I have have the working days of the calendar and the names with their assigned projects. I would need...

Hello, I have 2 data tables that get updated and carried forward every month. I have another tab that essentially has each table stacked on top of each other 8 times, with formulas and links to the data tables. When I insert new rows to the data tables, I would like the rows automatically...

I have two unformatted tables in my excel worksheet. The tables are vertical from one another. I have successfully created a macro button that adds 1 row under the header of the first table. However, adding a row to the second table simultaneously is where I am having trouble. What I want to...

Hi, I have a cell that is populated based on a user's input (Cell E9). I would like to create a macro that will then look for the last instance of the value E9 in a set of values (E39:E4000) and insert a row below that row. It would then also paste the value currently in H9 in J of that new...

Hi everyone, I am new to VGA, but I really need to get this button to work. I have a sheet with different tables. In my second table, I have 4 rows and 2 columns. The first column says 1st, 2nd, 3rd, 4th, and the second column is blank (besides having a thick border) for the user to fill in...

Hello mrexcel Community :) I have a problem with my VBA Code in Excel, I dont speak VBA or even english :laugh: The code I have tried to create is not doing what I want it to do. When I click on the Command Button than it does not create a new Row. The result of my tryings is this one...

Hi, I have a random list of numbers in column A and I would like to sort and insert rows and titles between certain number breaks. For example: Sort column from Z to A Insert a row between 0 & 59,000 and have 0-59K in bold in the inserted row then Insert a row between 60,000 & 99,000 and...

Hi all, I have a database, where in column "B" of one of the worksheets some cells are merged (by 2, 3 or more) and some are not. I want to number them in order that every single or "group-of-merged-cells" cell will have just one number. For example, 3rd + 4th are merged, 5th is single and...

Hello! I just started working with VBA this summer, and I have found so many answers to my questions by just searching this forum! Finally ran into a problem that I wasn't able to find a solution to by searching, and I decided to post and see if y'all could help. I am using Excel 2013 on...

Hi, I have this macro by which when you click the button, a row is inserted in that spreadsheet, this is the code: Sub textbox4_click() Range("G3").EntireRow.Insert Shift:=xlDown Range("G3") = Range("G4") + 1 End Sub However what i want to do now is ONLY allow for the button, which has the...

How can I automatically insert a row after each item type in column A to auto sum their totals in column I? 10096 9 10366 20 10366 29 10366 23 10370 20 10370 5 10370 13 10370...

How can I automatically insert a row after each item type in column A to auto sum their totals in column I? 10096 9 10366 20 10366 29 10366 23 10370 20 10370 5 10370 13 10370...

Dear Master, Could you please advise I would like copy the data in the new row other sheet below is the screen shoot what should it be Sheet 1 There are date, people , and color + number https://drive.google.com/file/d/0B995E_xrlb3STzd5VG5Jd2lmdVU/view?usp=sharing Sheet 2 If color is brown...

Hi, I'm trying to teach myself to write in VBA but many hours have shown this problem is way above my abilities at the moment. I have a very long list in a worksheet where column F contains one or more pipe diameter, and if there is more than one diameter for that particular line the cell...

Hello... I have a CountA formula, see below... =COUNTA('0 Data Summary'!B10:B108) I have a macro that creates a new client data row in row 10, and all other client data shifts down by 1. It works fine. Now, I have some formulas on Report tab that pulls this data using similar formulas like...

I have a spreadsheet with tables, one on top of the other, with some blank rows in between. For some reason now, I am unable to insert a row anywhere in the spreadsheet. I've tried converting the tables to a range, but I get an error that there are not enough resources to complete the function...

Hi All, Trying to create a macro whereby i can insert a new row and then fill that exact same row with values. This is what I have so far (fills the row below, not the actual new row). Any help will be appreciated. Sub Salesperson_Inputs() Dim Inputs As Range Set Inputs = Range("B16:BL16")...

I am trying to find a basic code to automatically insert a new row based on a cell value. I am using Excel 2010. To break it down further, here are the details. If any cell in the range "W5" to "W50" contains either "SP" or "TS", i want to insert a new blank row directly below whichever row...