Excel Macro Help Insert Row
Last answer on Mar 27, 2009 8:59:57 am GMT Someonenice, on Mar 26, 2009 4:29:21 pm GMTHello,
I need help with a macro for excel that will look at my sheet and if theirs data in Colomns D2:Z20.
If theres data in any of the columns after C2 I would like it to create a new row below the existing row and move the data thats in the column to a new row. Sorry my english not so good.
Here is example:
A B C D E G 1 2 GL 10100 SomeData GREENLAND HOLSTEINSBORG 3 GL 10101 SomeData GREENLAND Since their is Data in the Cell D2, E2, and G2 I would like to insert a new row below D2 (move everything down) and then move the E2 data and G2 (Cut and Paste) to the new inserted row that I just created it would be D3 and D4. Columns A B and C can remain blank. I just need to take the data that's after Dcolumn and put it on a new row below the existing one.
Configuration: Windows XP Firefox 3.0.7
Best answers for « Excel Macro Help Insert Row » in :
Inserting an animated gif in Excel ShowInserting an animated gif in Excel
To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control.
To insert the control, go to the View menu/Toolbars/Control Toolbox
Activate the first button Design...
Avoid duplicates in Excel ShowAvoid duplicates in Excel
In order to avoid duplication when encoding in a column from an excel sheet:
take the conditional format on the first cell under the headings (eg A2)
choose the following formula:...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel
Below is a tips of how to connect an Access database (MDB) in an application excel
Add reference
Microsoft DAO object librairy X.X
In a general module (eg Module1) paste the code below...
Hi,
|
See also Plus
Excel macro "moving row"- Excel macro cell backgroundcolor
- Excel macro change row color each change in data
- Excel macro delete row
- Excel macro find last row
- Excel macro find the last row empty
- Excel macro highlight row contains character
- Excel macro insert formula
- Excel macro insert row above selected cell
- Excel macro insert row after
- Excel macro insert rows below for each row
- Excel macro remove row with value
- Excel macro row and column dynamic reference
- Excel macro to compare cells in row
- Find column value in header row excel macro
- How can i get an excel macro to insert a 0 in a cell if no matching data is found in a search
- Insert sql query into excel macro
- Ms excel macro find value and go to that row
