Adding Multiple Rows Using Insert Copied Cells Function?

Feb 26, 2013

I have a spreadsheet with 27 Columns and 439 rows of data. I need to copy each row of data that has a certain criteria and paste the same data 141 times below it and then manipulate the data. In the same spreadsheet I need to copy a row of data that has other criteria in it and past it 30 times below it, and then manipulate the data.

I have been using the copy and insert copied cells function, but I have to scroll down 141 or 30 rows each time to ensure I add in the correct amount of rows. Is there a more productive way to do this? I have about 10 workbooks with approximately 47 tabs/worksheets each that I will need to update in a similar fashion.

View 4 Replies


ADVERTISEMENT

How To Use 'Insert Copied Cells' Function In VB

Jul 23, 2009

I've been trying to solve this for days. In Excel 2007 there is a 'Insert copied cells' function after copying cells and right-clicking on a cell which basically just inserts all copied cells to your desired location.

My question is, how do you call this function in VB, I've used F1 extensively and searched the net and haven't come up with an answer.

View 2 Replies View Related

Insert Copied Cells Into Multiple Locations Using Macro

Sep 14, 2009

I've been using the following macro ....

View 8 Replies View Related

Insert Copied Rows In All But 3 Sheets

Apr 19, 2008

One of the sheets in my workbook has 5 rows (Rows 1 - 5) that I need to copy and insert at the top of all but 3 of the other worksheets. I can specify the names of the 3 worksheets that I want to avoid changing. The other worksheets will be named differently each time I use the macro.

View 2 Replies View Related

Adding Multiple Cells From Multiple Sheets With Sumif Function

Jan 20, 2009

I'm trying to put together a spreadsheet that tracks disc capacity increases, affected by any incoming projects. I've managed to do so for one project, but would like to for up to 10. The way i've designed the solution (i'm sure there are far more elegant ways, but hey) is thus:

A forecast worksheet keeps track of a grand total, taking information from sheets P1 -> P10 (being projects 1 to 10). I am unable to figure a way to add up all the increases from all 10 project worksheets with one succinct formula. What I use so far is: ='P1'!C83+SUMIF('P1'!E82,"=2009 - Q1",'P1'!D82) ..................

View 5 Replies View Related

VBA Insert Copied Cells Shift Down

Sep 25, 2013

I'm using a macro to copy cells (2 columns and between 1 and 5 rows [19 - 23 on s/s]) from one workbook to another but if I use

Rows("2:2").Select
Selection.Insert Shift:=xlDown

then every cell in the inserted rows are populated.

this is what I currently have

Windows("agent master.xlsm").Activate
Range("B19:C23").Select
Selection.Copy
Windows("distribution master.xlsm").Activate
Sheets("L38").Select
Range("A2").Select
Selection.Insert Shift:=xlDown
Application.CutCopyMode = False

but that doesnt work either. It just gives me an empty cell in A2.

View 1 Replies View Related

How To Copy Row With Formula In Locked Cells And Insert Copied Cells In Protected Sheet

Mar 29, 2014

Have you ever copy a row with formula in locked cells & insert it in a protected worksheet?

View 1 Replies View Related

Insert Copied Cells Modification (Macro)

Jan 26, 2014

I don't know if a macro is necessary, but the built in Insert -> Insert copied cells -> Shift cells down function can't accomplish what I require.

I've pasted in two example tables for what I'd like to do. For the first table, the data in column C is a name and the cells from columns D-Z, rows 7-10 is what I want to copy and paste from row 12, column D; row 13, column D; etc, etc. However, I want the full rows below the name in column C to move down when I paste from column D. Using the Insert function on the Insert blade only gives me the data in columns D-Z moving down.

The second pasted table gives an example of how I want it to look.

A
B
C
D
E
F
G
H
I

[code].....

View 4 Replies View Related

Copy Only Values And Insert Copied Cells

Aug 1, 2006

i have some columns which contain the IF function and so it returns me a value in each cell. Is there any way to copy only the values AND insert shift down the copied cells onto somehwere else?

View 3 Replies View Related

Insert Multiple Blank Rows At Designated Cells

Jun 13, 2014

I have a large list of cells in excel: 15, 33, 90, 102, 149, 159, 217, 228, 238, 247, 305, 312, 369, 417, 428, 486, 538, 548, 606, 621, 671, 679, 737, 805, 816, 874, 915, 923, 981, 1029,1038 .

Under each of these cells I would like to insert 20 blank rows. I have tried various codes but i'm struggling with the fact that as soon as I insert 20 rows at cell 15, all the other cellnumbers change.

This is a reformulation of this post: [URL] ...........

View 1 Replies View Related

How To Copy Row To Last Row And Paste Copied Rows Directly Below Copied Contents

Oct 20, 2013

with a macro. I am looking to copy row 2 to the last row and past the copied rows directly below the copied contents.

View 9 Replies View Related

Extending Sum Function When Adding Rows

Dec 7, 2006

If I have a sum function that adds up:

= SUM(U41:U45)

but I add a row at 41 I now get sum function

=SUM(S42:S46) when I really want it to incorporate the just add row to look like this:

=SUM(U41:U46)

View 3 Replies View Related

Formulas To Be Copied After Adding Row?

Dec 20, 2011

I need formulas to be automatic added when i insert row

View 2 Replies View Related

Prevent Custom Function Running When Inserting/Adding Rows

Apr 8, 2008

I have a piece of code that hides unneeded rows, it does work but it is very slow.
This is in the worksheet part of the project. My problem is as it runs it "jumps" in to a function I have in a module that counts continuous rows. I would like to know why it is doing this and what I need to do to stop it? I have another piece of code that is structered exactly the same that hides unneeded columns and I do not have any problems with that. I know both pieces of code are dealing with rows and I think this is part of the problem but I can not see any reason why the first bit would call the second bit?

Dim C
With Worksheets("CEN OAS"). Range("D5:D378")
.EntireRow.Hidden = False
End With
For Each C In Worksheets("CEN OAS").Range("D5:D378")
If C.Value = "" Then
C.EntireRow.Hidden = True
End If
Next C

Function to count used rows....................

View 2 Replies View Related

Macro To Insert Auto Sum Function In Various Rows With A Column

Sep 4, 2009

I have to create a spreasheet monthly that has perhaps 60 transactions. The data is in columns A - G, with columns E and F having the costs figures. I need to sum the value in column E and also in Column F every few rows. The problem is that sometimes there are two rows per transaction and other times it could be 30 rows per transaction. Where I will be lucky is that there are two rows between transactions, and the sum goes in the first empty row.

Basically what I would need it to do, from a macro point of view is to go down column E, and every time it finds the first empty row, insert an auto sum. It would then need to ignore the next row, because it too, is empty.

Just Column E - I need an autosum in the "empty row 1's)

23.00
15.00
6.00
3.00
empty row 1
empty row 2
6.00
3.00
empty row 1
empty row 2
6.00
25.00
3.25
6.32

View 9 Replies View Related

Insert Copied Data From Sheet1 To Sheet2?

Apr 24, 2014

I have data in sheet1, which needs copied to sheet2

But in sheet2 already data is available. In Sheet2, i want code to go from header to down , to locate the first blank row in between data and to paste data by inserting same number of rows as number of rows copied.

View 3 Replies View Related

Insert A Line On New Worksheet With Copied Data

Jan 23, 2007

I need to add a line on the top of a new worksheet with the data copied from another worksheets cells. Using a macro. The line has to be created everytime on the top of the new excel sheet with the previous data moving one down.

View 6 Replies View Related

Function Or Macro To Insert Empty Rows Above Missing Flag

Apr 25, 2014

I am processing an infinite set of data from a meteorological station here in Alaska which gives me half hourly data reading with a time stamp 00.00, 00.30, 01.00, 01.30, 02.00, 02.30 and so on.

I am using this formula to detect every time half hour reading is skipped (=IF(TEXT(MOD(B1936-B1934,1),"[M]")="30","","missing")) and it works pretty well.
Still I have to check and manually insert extra missing for every half hour missing but that's bearable.

This formula inserts a "missing" every time it finds a gap.

My question is: How can I insert a row above every cell with "missing"?

How do I do that? Here is also my excel sheet.

CR1000_Meteo_20131113_2_CLEANED.xls

View 3 Replies View Related

Excel Macro To Insert Copied Row To The Cell Currently Highlighted

May 16, 2014

I have 4 rows that are on a "Resource" sheet need to be inserted into about 150 different variable locations across 20 different sheets. Here is the code I have so far the will copy it to one specific location (see below). I need making the macro insert these copied cells to which ever cell I currently have active. I'm still really new at VB programming so this probably something really simple to solve.

View 4 Replies View Related

Search Column, Match And Insert Copied Range

Apr 30, 2007

I'm currently trying to insert the copy range of one worksheet to another. Let's say I have 3 worksheets, one main and two additional info sheet. I want to search column C in main worksheet for blank cell and use column F in the same row as the worksheet name which I want to copy from, then use column E from main worksheet as the keyword for the range I want to copy(range from column E to column Z). But when inserting, I want the keyword in main worksheet such as 'G' in the same row as blank cell to match the 'G' in copied worksheet. Because the 'G' in main worksheet is not in the same column for each row, I try to search the forum but can't find the inserting part. I also attach the example workbook.

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

Adding Multiple Rows With A Macro

Feb 23, 2010

Ive made a simple macro in order to make easier to add new rows in a table, by filling the cells with the new data.

The problem is that according to one of the fields, Id like that macro to add multiple rows, with exactly the same information but numbering all these rows on this specific field from 1to the number I filled on the respective cell.

For example, I have beyond another fields that Ive already filled, the field "Parcel" and "Total of Parcels". I filled parcel with number 1 and total of parcels with 5. Then Id like the macro to add 5 rows with the "total of parcels" cells containing 5 on every row and the field parcel filled with number 1, 2, 3, 4 and 5, for each row created.

View 14 Replies View Related

Adding And Deleting Multiple Rows

Jul 9, 2013

I have a spreadsheet with multiple similar entries I would like to add up. What would work well for me is to be able to input a column like a and a target column like e.

So in this case it would search throughout column a and wherever it finds a duplicate entry add column e and then delete one of the rows. I could then run it again under different column criteria if needed.

So if I had the below sheet:

I could search by column a and add up column h to read like this:

View 1 Replies View Related

Insert Multiple Rows

Oct 29, 2009

Need code to insert multiple rows. I would like to be able to click a command button and have the number i have entered in a textbox be the number of rows inserted in the spreadsheet above a static cell like A12.

View 2 Replies View Related

Function To Insert - In Cells Splitting Data

Jun 17, 2006

My cell contents looks like this.

H1111111111111

I want it to look like this..

H11-111-111111-11

I know this can be done by formula but i dont know it. This info is in col B.

View 2 Replies View Related

Adding Multiple Rows Of Text In A Msgbox.!

Oct 7, 2009

I believe this would be a very simple query for some but I am a complete novice in VBa and am using a msgbox in one of my file but I need to split the message text into multiple lines but I do not know how to do the same.

View 6 Replies View Related

Insert Rows On Multiple Sheets?

Apr 2, 2008

I need to figure out a way to automatically insert rows and copy data on multiple selected sheets. for example, if i insert a row anywhere on sheet 3, i need that same row inserted in the same location with the cells populated with the same data on sheets 4, 6 and 9.

View 9 Replies View Related

Insert Multiple Rows And Label Accordingly

Oct 27, 2009

in inserting 8 rows as per the attached spreadsheet highlighted in orange, and labelling them, obviously, the year after the one above it.

View 10 Replies View Related

Insert Multiple Rows After Each Row Of Text?

Dec 1, 2011

I have a spreadsheet with about 10,000 lines/rows of text and I want to insert 4 lines/rows under each of these. way to do this efficiently without having to insert under every line/row?

View 9 Replies View Related

VBA To Insert And Delete Multiple Rows

May 30, 2009

Does anyone have codes to insert and delete multiple rows. I need to run a macro where a dialog box pops up requesting number of rows to insert and delete.

View 9 Replies View Related







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