Adding Rows Automatically Using VBA

Jan 3, 2014

I have a spreadsheet where I will input details for "incidents" under different headings on one row per entry (I will have a separate tab for each "incident", and each row will relate to each customer affected by this incident)

For every row that is completed I have a "Summary", which is just a section of the same worksheet, that will list all the basic details of the above entries in a format that will be printed and passed to a different department.

As I will be unable to determine whether a particular incident will have 5 entries or 50, I need a way to add a new row to my "Summary" section if and when a row is completed.

I have a formula to populate the data in the "Summary" section automatically, so all I need now is for it to add new rows as and when they are needed, copying the formulas from the original row, so each new "incident" entry is copied each time.

I have created a dummy spreadsheet but I'm not sure how to attach it to this post.

View 5 Replies


ADVERTISEMENT

Adding 5 Rows After Each Row And Automatically Populating Them

Jun 19, 2013

I have a data set of 300 points and i want to increase my data range by a factor of 10 .

For example if i have Column A with master points A1=10 A2 = 20 A3 = 30 .

I would like to be able to automatically enter in the same about of new rows between each point . Then calculate there difference between the master points and populate the new rows in sequence . For example The difference between A1 and A2 = 10. So the new A2 would be 11

I would like to have A1=10 A2=11 A3= 12 A3=14 Etc as the new cells.

View 1 Replies View Related

Automatically Adding Rows When Worksheets Are Added

Jun 30, 2014

I'm using a workbook that has one sheet that pulls data from all the others, displaying a series of rows that summarizes data from each worksheet, each of which is full of data. Its a worksheet that a lot of people use so its kind of tedious to use as of now, because whenever you add a new worksheet of data you have to manually create a row and then manually change all the worksheet references. Is there a way to make rows automatically add and update when a new worksheet is added? I know it would probably have involve some sort of Macro or VBA.

View 1 Replies View Related

Automatically Adjusting Sum Of Numbers When Adding / Deleting Rows

Jul 21, 2014

I currently have this formula to deal with this:

=SUM(J5:INDEX(J:J,ROW()-1))

However, whenever I delete the top row...I get a reference error and have to re-adjust...

View 7 Replies View Related

Automatically Adjusting Sum Of Numbers When Adding / Deleting Rows?

Jul 21, 2014

I currently have this formula to deal with this:

=SUM(J5:INDEX(J:J,ROW()-1))

However, whenever I delete the top row...I get a reference error and have to re-adjust...

View 9 Replies View Related

Complex Formulas Not Automatically Adjusting When Adding / Removing Rows?

Jul 11, 2014

I have this spreadsheet that I am creating schedules for my employees since our scheduling software at work is horrible to work with. It calculates total hours for each employee at the far right of the rows, and calculates total hours for each day in the columns. The formulas that calculate the hours for each day is set up to automatically deduct 30 minutes from a shift, for lunch, if they're scheduled for more than 5 hours (the gray shaded employee rows are for managers and that only deducts 30 mins if they're shift exceeds 8 hours).

I'm familiar enough to put somewhat complex formulas together, but I don't understand it enough to always make them work correctly. What I'm wanting to be able to do is add or subtract entire rows (add new employees or remove old), and have my formulas for calculating the total hours to still work. Right now if I delete a row the cell with the formula in it says #REF!. I can fix this by going through the formula and manually deleting everything in that contains those other cells, but the formula is huge, and it's pretty tedious going through the whole thing when it feels like there should be a simpler way of doing it.

TLDR: I want to be able to add/remove a row and have my cells currently on row 36 update the formula correctly.

View 3 Replies View Related

Adding A New Row Automatically

Feb 12, 2007

I have a work book of 3 sheets . the date in the first sheet are linked with the other 2 sheets , sometimes I have to add a row in the first sheet , within the the the table it contains ,

what I need is : a new raw is being inserted (created) in the other 2 sheets with tha same date I entered in the new row I added in the first sheet . beside the possibility to let me difine where that new row is being inserted in each of those other 2 sheets ( separately).

View 9 Replies View Related

Adding Up And Update Automatically

Feb 11, 2010

I require a total amount of 'cost price' items we have in stock.

As you can see from sheet 1, 'Adidas', the total is £43.00. However that is not the cost of stock, as some items are not in stock, as per Column I. (The cost is actually £36.00).

How can I make a total to include just items in stock? Bear in mind new stock is inserted between others in order of Model so the forumale would need to update automatically, and there are several hundred sheets, not just 2.

View 3 Replies View Related

Automatically Adding Mr Or Ms To Male / Female?

Apr 29, 2008

I have a list of data some with people titles, others with it missing. what i plan on doing is

D is the collum for title some are entered others are not. collum G has male and female already filled in.

is there a code to say if D is empty then look at G if it is female enter Ms in collum D and if male enter Mr in collum D.

View 4 Replies View Related

Adding Weekly Dates Automatically

Mar 25, 2009

how i can automatically add a week to a start date i have in a rotas for the whole year?.

View 3 Replies View Related

Going Down A Column Automatically Inserted When Adding New Row?

Jun 11, 2014

I have a formula in column G of a worksheet, however when a new row is inserted within the formula range, the formula does not continue in the new row.

Is it possible to make excel continue the formula without having to drag the formula down again?

View 6 Replies View Related

Automatically Adding Days Based Off Month

Oct 15, 2008

I am trying to automatically add the last day of the month based off of the month

for example

a1 = beginning date
a2 = end date

a1 will always be the 1st day of a given month

then based off a1, know the last day,(i.e.... october 1, then put 10-31-08 into a2, or november 1, then put 11-30-08......)

View 10 Replies View Related

Automatically Adding New Worsheets To Existing Sums

Nov 20, 2008

In the attached workbook I have 3 sheets. The first 2 with the names starting with WO are individual sheets based on a single scaffold rental. The "Standing Equipment" worksheet is adding the components from the other two worksheets. Easy enough, but I am looking for either a formula or some VBA guidance on how to have the "Standing Equipment" worksheet automatically change it's formulas to incorporate new worksheets as they are either added or deleted, thus avoiding constant formula editing as scaffolds are erected or dismantled.

View 3 Replies View Related

Automatically Adding Data With Multiple Criteria

May 26, 2009

I am having difficulty trying to consolidate a much larger version of the attached spreadsheet. I need to be able to have excel automatically add up the assets, based upon the firm ID. I have looked around and thought that SUMPRODUCT or SUMIF would work for what I need, but I've been unable to get either to work. I almost need to do a VLOOKUP and have it SUM at the same time.

View 3 Replies View Related

Paste Rows Without Overwriting Other Rows (automatically Shift Other Rows Down)

Jan 3, 2010

The number of rows you are pasting and then you can select that same number of existing rows and use "insert". This is what I'm trying to achieve:

(before paste)
A
B
C

(after pasting unknown number of rows)
1
2
...
n
A
B
C

Is there really no built-in way to do this?

View 6 Replies View Related

Automatically Daily Adding Or Remove Value From Excel Sheet?

Feb 15, 2013

One of my job responsibility the following up our store stock, usually we consume constant daily value form our stock, as example we used daily 200 mt of corn, 150 mt do soya bean meal and so on, I would like to creat excel sheet to deduct this value from the previous column daily automatically.

View 1 Replies View Related

Making Formulas That Automatically Update When Adding Cells

Jun 9, 2014

I want to make an excel workbook for a client. What I want to do with it is make a set of instructions telling them to add or insert as many rows in specific categories I have made for them. These options differ depending on the different duties performed. There will be an associated number (value for that duty, ex. duty might be Janitor and the number would be like 5 dollars per hour, so on and so forth), I want to make it to where there is a code that notices more rows and adds more IF statements or whatever statements are needed to keep adding those extra options. These values are connected to a data validation list that drives the if statement.

View 4 Replies View Related

Adding 2 Rows After Every One Row

Jan 29, 2009

I need some help fomulating a VSB code which would add two rows after every one row.

View 7 Replies View Related

Adding Rows With VBA

Apr 18, 2008

We have workook with several worksheets (tabs). The main page has several headings (category), including "Doors and Ceilings", "Walls" etc. There are currently three rows under each heading. When I go to a category (tab) there is a list of issues in column b. I can go to column A of each issue and if I place an "a" that issue will be copied to the main page under that category. The problem is that i only have 3 rows and I need a row added each time an issue is transferred to the cell before it.

Is there some VBA I can use to detect the precence of data anbd add a row?

View 9 Replies View Related

Adding Two Rows After Every Existing Row

Aug 7, 2009

Is there any way to automatically add two new rows after every existing row containing data?

For example

1 A B C
2 D E F
3 G H I

turn into

1 A B C
(empty row)
(empty row)
2 D E F
(empty row)
(empty row)
3 G H I

View 9 Replies View Related

Adding Rows With Data?

Mar 14, 2013

I have got a spread sheet (Attached) that works out the rankings of youth football teams so that they can be given fixtures against teams of the same ability. I want to use the same system for another age group which has nearly 100 teams in it but I can't get it to work for over 50 teams.

With my basic Excel knowledge I have worked out how to add extra columns with the correct formula, but I can't work out how to add rows with the correct formula to the table that is in cells A12 -C12 down.

Ideally I would also like this table to show the team with the highest ranking in position 1 & in descending order from there - but I would be more than happy just to add the extra rows for now.

View 5 Replies View Related

Adding Two Rows Together If They Have The Same Value In Column A

Oct 7, 2008

I've got an excel sheet which has names in column A followed by 5 numerical values in columns B-F. I'd like to get a macro that will compare the values in Column A and if they match, add the B values, the C values, the D values, the E values, and the F values and delete one row - effectively combining the row. What's the best way to go about this? Also the sheet is already in ascending alphabetical order by Column A, so the rows that need adding will be next to each other. So I guess compare each A value with the one below it and if they match add the rows, but how?

View 5 Replies View Related

Adding Conditional Rows

Jul 10, 2006

I want to be able to have rows/cells generated with a certain text
based on the answer given by a user.

For example, My question in a cell could be "how many groups have you made?".
Now to this if the user answers "3" then I would want three cells below to
ask "what is the name of your first group", "what is the name of your second
group" and so on.

View 11 Replies View Related

Updating By Adding New Rows

Mar 1, 2008

i have rows of data in an accounting worksheet (payments in/out) which needs constant updating by adding new rows. within the row a formula exists in column D such as =SUM(E11:J11) and the next row is =SUM(E12:J12). if i select row 12, right click and select insert, a new blank row 12 appears but without formula in column D. is it possible to insert row with retained formula? i would prefer to add a row from a blank row below current row and have new row appear with above rows formula but this is not vital.

View 12 Replies View Related

Adding Comments To Many Rows In Vba

Feb 15, 2007

Is any way to add automatically comments in VBA

Some combination of "ctrl" with something else.

View 3 Replies View Related

Formula For Adding 12.5% Onto Multiple Rows?

Apr 25, 2014

I have a quotation that I am working on that I need to add 12.5% onto each seperate line price.

There are 300 individual lines on the quote all with different pricing but they all need 12.5% adding on so I am hoping there is a simple way to do a bulk sum for all of the rows rather than having to go through each row and creating a sum for each. - ie =(K28*1.125)

View 3 Replies View Related

Form Development - Adding Rows

Dec 16, 2009

I'm creating a spreadsheet to generate a standardized form that I use as a paralegal.

I have 2 things that I don't know how to create....

1 - I want to have y/n questions on the data entry tab. When boxes are clicked Y, it adds a row and language to the form which exists on another tab. I know how to do links and to do if then statements, but I don't know how to make it not take up space when the answer is n. Some of these clauses are pretty long so I don't want to have big blank spaces when the answer is no.

2 - I have certain sections where I need to control the number of rows. I want to have a cell on the data entry tab where I put in the number of rows that I want. The spread sheet would create those rows and I would then enter the data on the data entry tab. On the form tab, the spreadsheet would refer to the cell telling it the number of rows, add those rows, and link them to the data that I entered on the data entry tab.

View 9 Replies View Related

Adding Rows To Sheets With 3D Referencing?

Jun 13, 2013

I have attached a file for reference. I have another file I use that is similar to the one attached, however it has 500+ rows and is still growing. The issue I am having is that in this file I want to make a "Template" worksheet. Basically I need 50ish sheets that are more or less the same. I have a column that describes a item, a items weight, a row with headers for the columns that I want to appear identical on every worksheet. I want the variables to be the count. These will change from sheet to sheet with formulas to than update the totals.

My issue I am having is that I constantly find myself needing to insert new rows for new items. In my real worksheet I have rows grouped together in a logical way so the rows cannot just always be placed in the next available row at the end of a sheet. How I can have sheet 1 be my "template" and the others take their item lists and weights from sheet 1. In the example file I created sheet 1. I than created sheet 2 and selected a cell entered "=" and selected the cell that I want it to have the same info from on sheet one. I fill handled these items down to generate a list. I than held down control and dragged a couple of new sheets. This process works, and is what I am currently doing, but what do I do when I wish to add a new rob between row 4 & 5?

View 2 Replies View Related

Autofiltering Then Adding Value To Filtered Rows?

Jul 25, 2014

I am able to autofilter a sheet to show only rows with a date in Column U but no "x" in Column BC. Now I want to be able to put an "x" in BC in only the filtered rows. The purpose is if someone enters a date in Column U, the macro will show only those rows minus the rows that have already had an "x" added to BC.

For the most part I've gotten this to work using but it will also put an "x" in Column BC, row 3001 on down.

How can I get it to stop at the last row?

Cells.AutoFilter Field:=21, Criteria1:="<>"
Cells.AutoFilter Field:=55, Criteria1:="="
Columns(55).SpecialCells(xlCellTypeVisible).Value = "X"

View 5 Replies View Related

Adding Rows And Calculation To Macro

Nov 3, 2008

I am extending rows on a salary schedule. As you can see below, the rows include: Bargaining Unit (GP) Schedule(2A) Range(5) Step (A) Hourly (S) and the hourly wage(11.52)

GP,2A,5,A,H,11.52
GP,2A,5,B,H,11.82
GP,2A,5,C,H,12.17
GP,2A,5,D,H,12.5
GP,2A,5,E,H,12.88
GP,2A,5,F,H,13.22
GP,2A,5,G,H,13.61
GP,2A,5,J,H,14.18
GP,2A,5,K,H,14.71
GP,2A,5,L,H,15.26
GP,2A,5,M,H,15.83

The Steps currently go from A thru M but I need to add N thru Z and after step M there is a 3.75% increase for each step.

You can see that this is a csv file (comma delimited). All of the other info needs to autofill and only the new steps (N-Z) will change and the wage for each of the new steps. The last row is 2 decimal points.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved