Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy/paste scenario
Hello all-
I have a 5500 row spreadsheet. The info on the even rows needs to be added to the end of the odd rows. Any quicker way than cutting/pasting every even row to the end of the odd row? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy/paste scenario
Sub appendeventooodd()
lr = Cells(Rows.Count, "a").End(xlUp).Row For i = lr To 2 Step -2 Cells(i - 1, "a") = Cells(i - 1, "a") & " " & Cells(i, "a") Next i End Sub -- Don Guillett SalesAid Software "ohdharleyboy" wrote in message ... Hello all- I have a 5500 row spreadsheet. The info on the even rows needs to be added to the end of the odd rows. Any quicker way than cutting/pasting every even row to the end of the odd row? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy/paste scenario
Thanks Don-
Do I run this as a formula or as a script against the workbook? "Don Guillett" wrote: Sub appendeventooodd() lr = Cells(Rows.Count, "a").End(xlUp).Row For i = lr To 2 Step -2 Cells(i - 1, "a") = Cells(i - 1, "a") & " " & Cells(i, "a") Next i End Sub -- Don Guillett SalesAid Software "ohdharleyboy" wrote in message ... Hello all- I have a 5500 row spreadsheet. The info on the even rows needs to be added to the end of the odd rows. Any quicker way than cutting/pasting every even row to the end of the odd row? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy/paste scenario
This is a macro, not a formula. It should be pasted in a module in the
visual basic editor... Post back if you have questions. Dave -- Brevity is the soul of wit. "ohdharleyboy" wrote: Thanks Don- Do I run this as a formula or as a script against the workbook? "Don Guillett" wrote: Sub appendeventooodd() lr = Cells(Rows.Count, "a").End(xlUp).Row For i = lr To 2 Step -2 Cells(i - 1, "a") = Cells(i - 1, "a") & " " & Cells(i, "a") Next i End Sub -- Don Guillett SalesAid Software "ohdharleyboy" wrote in message ... Hello all- I have a 5500 row spreadsheet. The info on the even rows needs to be added to the end of the odd rows. Any quicker way than cutting/pasting every even row to the end of the odd row? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy/paste scenario
Thanks Dave and Don - this worked like a charm!
"Dave F" wrote: This is a macro, not a formula. It should be pasted in a module in the visual basic editor... Post back if you have questions. Dave -- Brevity is the soul of wit. "ohdharleyboy" wrote: Thanks Don- Do I run this as a formula or as a script against the workbook? "Don Guillett" wrote: Sub appendeventooodd() lr = Cells(Rows.Count, "a").End(xlUp).Row For i = lr To 2 Step -2 Cells(i - 1, "a") = Cells(i - 1, "a") & " " & Cells(i, "a") Next i End Sub -- Don Guillett SalesAid Software "ohdharleyboy" wrote in message ... Hello all- I have a 5500 row spreadsheet. The info on the even rows needs to be added to the end of the odd rows. Any quicker way than cutting/pasting every even row to the end of the odd row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
faster, more effective scenario analysis? | Excel Discussion (Misc queries) | |||
Scenario Manager | New Users to Excel | |||
Creating Scenarios and Scenario Manager | Excel Worksheet Functions | |||
Scenario Function | New Users to Excel | |||
Copy/Paste in Autofilter | Excel Discussion (Misc queries) |