I would like to know how can i insert a blank row in between ACC# when ever a new series of data begins
name Acc # Balance Date
John 2222 200 june 2013
John 2222 344 june 2013
John 2222 700 Sept 2013
Silva 4444 333 June 2013
Silva...
Good morning,I am trying to write a VBA script that inserts a row every time a cell value changes. The number of rows that contain cell value A, for example, is a dynamic number (e.g. there's no set number of rows). Below is my code:myrows = WorksheetFunction.CountA(ws1.Range("A:A"))For i = 2 To...
Excel 2007 and 2010
Windows 7
This should be easy for me but it's not working.
1) I have a workbook with a Master tab named "pivot sequence".
2) The other sheets in this same workbook have different names - and their header titles are all on row 1.
I need to insert 5 blank rows above the...
Hey All
I'm am trying to figure out a macro to run that:
If cell on Column B (let's say B5) equals "1" "2" or "3"
Then insert (below) the the number of rows that the cell in F5 equals
So, if "1" shows up in cell B5, and if F5 equals 3, then 3 blank rows would be added below row 5
Then, go...
Hello,
Am currently an intern and a VBA newbie. Looking to write a code that inserts rows from one master template sheet and enters them into another interview sheet.
The template may change and this process needs to be repeated a certain number of times. (this number is set of certain cells...
Hello,
I need to do two things, can be two seperate macro's. 1. I need to insert a blank row every other row in a selected range. 2. Then I need to move the data from Column G into column B in the newly created rows.
The number of rows I have varies each month.
Sample is I have 80 rows of...
I need to insert and delete rows in a protected worksheet. When I set the protection, I indicate the user can access unlocked cells, insert and delete rows. After I save the worksheet and try to add rows, it will let me but it will not let me delete rows althought the access box to that task...
I have a hidden worksheet ("RawDataSheet") that pulls from a database, on which column "O" contains the month, i.e. August, September, etc., but not necessarily ALL months. I've written a short macro that finds the distinct months in "O" and copies/pastes them into another worksheet...
<tbody>
columnA
aaa
columnB
1
bbb
0
ccc
0
ddd
0
eee
4
fgh
2
</tbody>
Hi there, am trying to write a code so rows are ( or not ) inserted depending on the value of the cell.
If cell value is 0 or 1, there shoulb be zero row inserted.
if cell value is 2 or greater, there should be 2...
So I have recorded a macro that filters for certain criteria in a master list of projects, then copies the projects that meets this criteria and pastes it into a timeline in another worksheet. However, because the list of projects gets bigger and smaller when the filter criteria changes, right...
I am trying to insert 6 blank rows after every 6 rows of data using a macro. I have this code but it just inserts 1 blank row every 6 rows of data.
Sub Insert7thRow()
Dim rCell As Range, l As Long
For Each rCell In Selection
l = l + 1
If l Mod 7 = 0 Then rCell.EntireRow.Insert
Next...
I have been kindly supplied with the following code that allows the Document User to define the number of rows to be inserted in a Worksheet.
Currently this code copies row 3 and pastes it the defined number of times beneath the last used row.
However I would like to tweak the code so that...
Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p> </o:p>
Using Excel VBA I am looking to automate a basic Copy and Paste routine which amounts to little more than copying row 3 and then pasting it in the next blank row below.<o:p></o:p>
<o:p> </o:p>...
Hi All,
I have searched but was unable to find what I was looking for. I have a set of rows that I have copied in an Excel table. I then want to insert these copied rows every 40 lines but with a user input box that lets you choose which row to start at. For instance user can input row 45 and...
I need to insert a random number of rows in excel and fill the cell value incrementally by one on each row.
I found the following formula that inserts the blanks rows and copies the value to each row. I want the value to increment by 1 for each new row. It prompts the user for the number of...
Hi, I'm a dunce in Excel, but actually managed to insert an "average" formula, though would like to add more data above it, to average more cells.
If this is answered in another thread/post here, feel free to send me its link. I was unable to find it.
I saw something on another site talking...
I have a worksheet which contains formulas and validations in Row 5. If a user needs to insert rows, I'd like to prompt them to ask them "how many rows would you like to insert?" and then insert the requested number of rows below Row 5. I would then like to copy all of Row 5 and paste into the...
I must admit I don’t know how to write macros in Excel so I wonder if someone can help.
I have the dataset that looks something like that:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
Column A Column B Column C...
Forgive me if I don't know what I'm talking about, I'm a newbie to Excel macros. I have a large spreadsheet with over 2,800 rows and 66 columns. The data is sorted thusly: Column A (major), column B, Column D (minor). I would like to have a macro that inserts 1 row when the data in column B...
I have a column A1-A1000 of numbers.
What is the fastest and easiest way to insert 3 rows between each number.
Currently ...
1001
665
426
etc
I want ...
1001
665
426
Thanks
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.