Insert Rows At Specifice Location

Nov 30, 2006

I need a macro that will look in column B of a worksheet for the value "Grp2" and begin inserting rows underneath that value based on a variable that I will pass to it. The variable will be how many rows to insert.
For example if value "Grp2" occurs in cell B19,beginning at cell B20 I want to insert a specified number of rows.

******** ******************** ************************************************************************>Microsoft Excel - Test2.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutJ19=
ABCDEFGHI19XLRTGrp2CODERTSCFLTROASMLTGDOP*20*Begin*insert*rows*here*******21*********22*********23*********24*********25********326XLRTGrp3CODERTSCFLTROASMLTGDOP*27*********Test*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View 9 Replies


ADVERTISEMENT

Insert Row At Variable Location

Dec 3, 2009

I had a quick question for something that should be simple but I can't figure it out. I have a column of sorted values, it goes

A
A
A
A
A
B
B
B
B
B

and I want to insert a row to separate the A's from the B's. But there will be a random number of A's. I can figure out how to count where the A's end. But I can't figure out how to insert a row. Any suggestions? I tried the two below but they don't seem to work. The for section is counting the A's, and it works, it's what comes next that's giving me a headache!

View 2 Replies View Related

Insert An Icon Relative To The Button Location

Jul 30, 2009

I was wondering if i could get a hand with inserting a file. Is there a way to insert the file and have it placed a relative distance from the insert button without using cell references?

View 2 Replies View Related

Insert The 'location' Of File Into The Spreadsheet Footer

Jan 21, 2010

I would like to use macros to insert the 'location' of my excel file into the spreadsheet footer. I have the following code already:

View 3 Replies View Related

Insert Row At Specific Location And Auto Fill Formulas From Above

Apr 11, 2007

What I need is to insert a row at row 59 and autofill the formulas including drop down list from the above row. This is what I have so far (Thanks to Reafidy and shg).

Sub ChkDates()
Dim c As Range
Dim DelRng As Range
Dim ArcRng As Range
Dim i As Long
Dim l As Integer
Application. ScreenUpdating = False
Worksheets("Report").Activate
For i = 60 To 8 Step -1
Set c = Cells(i, 33)
If IsDate(c) Then ..............

View 9 Replies View Related

Searche A Specifice Numbers

Sep 3, 2007

I am trying to create an Excel database where I input a number and it finds the information that I am looking for.

For example, I have a list of 20 different companies that each have various supply numbers for properties ranging over a period of around 400,000 numbers spread out over between them. I want to be able to input a specific supply number on the database and it provides me with the relevant area, contact number for the company, and address etc.

So if the number that I input falls between 3000 and 4000, the details for one company appear. However if I input another number between 4000 and 5000 then a different company name appears.

View 9 Replies View Related

VBA Filter On Specifice Date

Aug 20, 2008

I am writing a simple macro and trying to filter on a specific date. I thought it would be as simple as this;

Dim mydate As Date
mydate = Range("r4")

Range("A3:K3").Select
Selection.AutoFilter
Selection.AutoFilter Field:=7, Criteria1:=mydate, Operator:=xlAnd
Range("A2").Select

The filter doesn't seem to work as it doesn't return any results, even though there are results in the table.

View 9 Replies View Related

Hyperlink To A Specifice Cell

Apr 8, 2009

I am working with Excel 2007. I have a work book with several worksheets full of job data including names, job codes, titles, and descriptions. On one sheet I have names, job codes and titles that I have matched to my companies current personnell data. On the other sheet I have survey job codes, titles and descriptions. I need a hyperlink formula that will take someone comparing the two jobs straight to the description to for comparison information. There are too many hyperlinks needed for me to manually choose the specific cell I need. I am very willing to send an example.

View 9 Replies View Related

Print Specifice Worksheets

Feb 14, 2007

I am looking for a way to have print icons on my spreadsheet that will print certain worksheets once clicked on.

For example: My spreadsheet has several countries, UK, France, Germany...

If clicking on the print icon next to Germany - i would like only the German worksheets to be printed - there would be several worksheets for each country.

View 9 Replies View Related

Deleting Specifice Lines With A Macro

Apr 16, 2008

I have a question for you that can be much helpful for me. I prepared a macro which is collecting many datas from different pages and entering them on a sheet. Some lines of this sheet are with data and some are empty. I would like to write a code, which will delete the lines in which there is no data. But I would like the code to do this between line 5 and line 225.

View 9 Replies View Related

Sum Rows Based On Location

Mar 2, 2007

See the attached sheet. i need a formula that finds the word "Find Me" and performs the calculation written to the side of the word "find me", and stops with the word "finished". the difference in rows between "find me" and "finished" varies. i am at a loss on this one.

View 6 Replies View Related

Moving Rows To A Specified Location

Jun 16, 2008

I am trying to do work on a sheet and am getting very frustrated. I have a list of several different data entries that contain a row of information. I need to have the excel sheet move these rows to a different sheet in a specified location. For example, in the first column of the data I have the list of commodities, (sugar, cotton, yen, euro, and copper). Then in the second column I have the price and then the quantity. I want to move them automatically from sheet 1 (where they are entered) to a specific location on Sheet 2. I want Cotton to be in A2, Sugar to be in A20, Yen to be in A30, Euro to be in A40 and copper to be in A50. I would like the data to be cut from sheet one and inserted into sheet 2 so that the sheet can move them every day.

View 4 Replies View Related

When Check Boxes Click Data Appear In A Specifice Cell

Jun 6, 2008

I'm attempting to use VB in excel. I've created a form and several check boxes with specific options for each one.

when one box is clicked I want the data from that box (whatever the option is) - to appear in a specific cell (ie: cell 17)

View 9 Replies View Related

Populate A Given Number Of Rows Starting At A Specific Location

Jun 2, 2014

I have a spreadsheet where I track resources needed on a project. Each resource that is selected in the resource column has a corresponding % avg and an average number of months where the resource is used. % Avg and # of Months are found in a different worksheet.

What I am looking to do is, for example: if resource A will be on the project starting in May 2015 and assigned at 30% for 7 months, I want to populate 30% starting in the colunm labeled May 2015 and copy the 30% so that a total of 7 months are populated. Also, if any of the values change (i.e: the Resource Name or the Start Month) I want to erase all the percentages that were entered in the row. How can I achieve that with a VBA code? I have formulas that retrieve the # of Months and the % Avg already.

These are the columns that I have in my spreadsheet:

Resource NameStart MonthJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15

View 2 Replies View Related

Interpolation Given A Variable Table Location & Location Of Data Within

Oct 6, 2009

I am trying to develop a spreadsheet that will calculate a cost based on a matrix. I am attaching a sample of the calculation created so far. The end result is in cell M13 and is highlighted in yellow. I kind of layed the formula out in a few different cells, so hopefully it would be easy to follow.

simplify this process with maybe another formula that I might not be aware of, or maybe show me how to get this done in VB code. I think VB code would be the correct way to go just not sure.

View 6 Replies View Related

Maro, Insert Rows Where Rows Determined By Number Of Carriage Returns

Feb 17, 2010

The best way to explain my problem is to look at the table below:

How it looks now: ApplePrice 1
Price 2
Price 3FruitDeliciousPearStore 1
Store 2FruitVery DeliciousHow I want it to look:ApplePrice 1FruitDeliciousApplePrice 2FruitDeliciousApplePrice 3FruitDeliciousPearStore 1FruitVery DeliciousPearStore 2FruitVery Delicious

View 9 Replies View Related

Macro To Split Rows Into Groups Of 5 And Insert 3 Blank Rows In Between

Feb 9, 2013

I would like to have my macro code search column A (supplier numbers) and split the rows into groups of rows of 5 or less and then insert 3 blank rows between each group of rows. The split needs to start on a new supplier number and cannot split a supplier number into two different groups. Here is a sample:

Supplier
Invoice Date
GL Date
Invoice Amt

[Code].....

View 1 Replies View Related

How To Dynamically Insert Rows With Duplicate Data Of Previous Rows

Oct 30, 2013

I have a spread sheet with values in the area of A1:H834

In column H, I have number values from 1-7.

Essentially that number value means that the values in the row are duplicate.

So, for example, if H2 has a value of 4, that means that $A$2:$G$2, really should have an additional 3 rows underneath with the EXACT same data in each cell, however, the way the sheet was created, was to remove the duplicate values and just indicate in column H, the number value of how many duplicates $A$2:$G$2 really is.

I need to unpackage this and create what it was originally. What type of formula can I use, to look at the value in H2, and then insert underneath that number of rowes with the exact same data as A2:G2 and do the same for the remainder of the table all the way down to A834:G834

View 1 Replies View Related

Macro To Insert New Rows Based On Commas In Previous Rows?

Mar 15, 2014

I'm a macro novice and have been trying to teach myself how to write the correct one for a task I need to do, but I cannot seem to get it right. Basically, I have bunch of data and for one of the variables, different values are separated by commas. What I want is to create a row copying the info below for each piece of data after the comma.

Sheet1

A
B
C
D

[Code].....

I suspect there is a fairly easy way to do this, but I cannot figure it out from searching the forums (or rather, I can't get it to work right).

View 6 Replies View Related

Insert Blanks Rows In Alternate Rows But Ignore If Already Blank

Jun 26, 2014

i have this code which inserts blank rows in alternate rows,

Code:
Sub insertrow()
' insertrow Macro
Application.ScreenUpdating = True
Dim count As Integer
Dim X As Integer
For count = 1 To 20
If activecell.Value "" Then
activecell.Offset(1, 0).Select

[code].....

what changes should i make in this code to insert rows only when ther are now blank rows. So first time i run, blank rows are already there, and when i update some data at the bottom and re-run it inserts blank rows again.

View 3 Replies View Related

Insert Rows Subject To Conditions In Rows Above And Below

Jun 21, 2008

as per the attached, need to insert those grey rows subject to the following condition :

if current row date <> next row date, .and. current row latitude / longitude <> next row latitude / longitude , insert grey row with date = current row date, else insert grey row next row date

note that the coordinates in the repeated grey rows, for the "Home" location, are the same through the sheet, should be entered by the user, at the beginning of the process, since there will be a spreasheet per user.

date is in column K
latitude / longitude are in columns B / C

this will be of tremendous assistance in automating mileage claim review.

View 8 Replies View Related

Insert 2 Rows Wit Formula After Every 6 Six Rows

Apr 10, 2014

For my thesis dataset I am looking to insert two rows after every six rows (the company name) in a dataset with approximately 30,000 rows.

For the first extra row that would be cell 4/cel6
For the second row that would be cell 5/cel6

A picture is added below in which I have manually entered these formula. Is there any way to make this a swift operation rather then a manual one?

untitled.JPG

View 1 Replies View Related

Put All Values Of A Specifice Line In That Matrix In A Line

May 20, 2008

I'm working with matrix in vba and i'm trying to put all values of a specific line in that matrix in a line in excel. For example:

Matrix =
1 2
3 4

and i want Range("B1:B2") = 3 | 4 (the second line of that matrix).
Is there any way of doing this without perfoming a loop?
[something like Range("B1:B2").value = 'range'(matrix(0,0) , matrix(0,1)) ]

View 9 Replies View Related

Insert All Of The Rows At Once

Mar 12, 2007

Is there a way to have a sort of programmed button that could be pressed that would insert all of the rows at once? Or perhaps a new line could be generated for each table with the only missing data being the values that would have to input manually?

To make it more clear I have attached a sample table. In the sample table, what I would want to do is insert a row at row 47 and at row 93. I want to do these at the same time easily. Keeping in mind that there are 40 some other tables arranged in series like that in one single spreadsheet. I cannot simply hit ctrl and select the two rows and then insert both rows, this would be equally as time consuming to do for all of the rows that would have to be added. Also, in the attached table, most of the values are either calculated values or are hard set numbers. The manually inputted values occur in columns B, E, and F. Everything else is copied down from the previous line.

View 9 Replies View Related

Rows Insert?

Oct 31, 2008

Why is my code below doesn't work on Book2. The code is on Book1. If I'm on Book2 and run the macro, it applies the macro on Book1 and not Book2.

View 4 Replies View Related

VBA To Insert Rows ...

Jan 21, 2009

I have file which is repeating, and i want to insert a row after the end of each repitition.

here is my sample data from:

123sat
123sat
444mat
444mat
444mat
555abi

to:
123sat
123sat
new row insert
444mat
444mat
444mat
new row insert
555abi

I know it involves a macro and i dont know how. pls help as its a HUGE data and i need to automate it.

View 12 Replies View Related

Insert Rows Every Nth Row

Aug 27, 2003

How to add a row in a spreadsheet every say 5th row OR add a row whenever a specific string or value is found?

View 9 Replies View Related

VBA To Insert Row Every X Rows

May 13, 2013

I am wanting to insert a new row after every 6th row in a spreadsheet that contains in column A of each new row the text xxxx.

View 2 Replies View Related

Insert The Rows

Jun 17, 2008

I had fix my rows is from 1 to 100,and each ten rows consists as one row and I had use border to separate each ten rows.(Eg,row 1 to 10 is 1row).....So when I click a button and I choose to add 10rows after row 20,how can I do so? because when i choose to add 10rows after row 20,the existing row start from 21 will move down....But the problem is I had fix my rows to 100 only...How can I do so that the row 21 will move down and at the same time check the total of rows will not exceed 100?

View 9 Replies View Related

VBA To Insert Rows

Oct 27, 2009

I need to insert 2 blank rows within a spreadsheet above certain other rows that contains data that starts with a particular text string.

Details:
Column A has office codes in the form of "0301A", "0301B", etc.
Column F will have billing codes that could start with either "L" or "ND" or "NF".

Problem:
I want to separate the L's from the ND's and also the NF's in column F based on which office they are billed to.

End result:
What I want to end up with are two blank rows in between each office code in column A, then another two blank rows between the L's, ND's and NF's.

View 9 Replies View Related







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