Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Insert New Rows based on COUNTA()
This might not be the right area however i am a newbie to Excel so i figure i'd start here. I have very limited experience with Excel so excuse me if i don't make sense. ANY HELP IN THE RIGHT DIRECTION WOULD BE AWESOME I have a Column full of keywords, and i have a column full of Ad IDs... is there a way in a *new* sheet to insert the keywords in as many times as there are ads? SHEET 1 Keyword 1 | 123 Keyword 2 | 456 xxxxxxxxx | 789 SHEET 2 Keyword 1 | 123 Keyword 1 | 456 Keyword 1 | 789 Keyword 2 | 123 Keyword 2 | 456 Keyword 2 | 789 I found COUNTA() Which lets me count how many keywords and ads i have, i'm just not sure what to do with those numbers now. -- TheDPQ ------------------------------------------------------------------------ TheDPQ's Profile: http://www.excelforum.com/member.php...o&userid=30915 View this thread: http://www.excelforum.com/showthread...hreadid=505922 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Insert New Rows based on COUNTA()
If I've got you right, perhaps this will help?
http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "TheDPQ" wrote in message ... This might not be the right area however i am a newbie to Excel so i figure i'd start here. I have very limited experience with Excel so excuse me if i don't make sense. ANY HELP IN THE RIGHT DIRECTION WOULD BE AWESOME I have a Column full of keywords, and i have a column full of Ad IDs... is there a way in a *new* sheet to insert the keywords in as many times as there are ads? SHEET 1 Keyword 1 | 123 Keyword 2 | 456 xxxxxxxxx | 789 SHEET 2 Keyword 1 | 123 Keyword 1 | 456 Keyword 1 | 789 Keyword 2 | 123 Keyword 2 | 456 Keyword 2 | 789 I found COUNTA() Which lets me count how many keywords and ads i have, i'm just not sure what to do with those numbers now. -- TheDPQ ------------------------------------------------------------------------ TheDPQ's Profile: http://www.excelforum.com/member.php...o&userid=30915 View this thread: http://www.excelforum.com/showthread...hreadid=505922 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Insert New Rows based on COUNTA()
You could use a macro:
Option Explicit Sub testme() Dim myCol1 As Range Dim myCol2 As Range Dim myCell1 As Range Dim myCell2 As Range Dim wks As Worksheet Dim newWks As Worksheet Dim oRow As Long Set wks = Worksheets("Sheet1") With wks Set myCol1 = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp)) Set myCol2 = .Range("b1", .Cells(.Rows.Count, "B").End(xlUp)) If myCol1.Cells.Count * myCol2.Cells.Count .Rows.Count Then MsgBox "Too much data!" Exit Sub End If End With Set newWks = Worksheets.Add oRow = 0 For Each myCell1 In myCol1.Cells For Each myCell2 In myCol2.Cells oRow = oRow + 1 With newWks.Cells(oRow, "A") .Value = myCell1.Value .Offset(0, 1).Value = myCell2.Value End With Next myCell2 Next myCell1 End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm TheDPQ wrote: This might not be the right area however i am a newbie to Excel so i figure i'd start here. I have very limited experience with Excel so excuse me if i don't make sense. ANY HELP IN THE RIGHT DIRECTION WOULD BE AWESOME I have a Column full of keywords, and i have a column full of Ad IDs... is there a way in a *new* sheet to insert the keywords in as many times as there are ads? SHEET 1 Keyword 1 | 123 Keyword 2 | 456 xxxxxxxxx | 789 SHEET 2 Keyword 1 | 123 Keyword 1 | 456 Keyword 1 | 789 Keyword 2 | 123 Keyword 2 | 456 Keyword 2 | 789 I found COUNTA() Which lets me count how many keywords and ads i have, i'm just not sure what to do with those numbers now. -- TheDPQ ------------------------------------------------------------------------ TheDPQ's Profile: http://www.excelforum.com/member.php...o&userid=30915 View this thread: http://www.excelforum.com/showthread...hreadid=505922 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
List rows in an order based on a cells value | Excel Discussion (Misc queries) | |||
How to quickly insert a blank row every 5 rows? | Excel Discussion (Misc queries) | |||
Simultaneouly insert of rows or col. - Ajit | Excel Discussion (Misc queries) | |||
INSERT ROWS WITHOUT SCREWING-UP FORMULAS! | Excel Worksheet Functions |