MACRO to copy / paste cell text down various rows [Solved]
debtiger99
Moderator Last seen
December 4, 2018
- Aug 14, 2018 at 11:26 AM
- Posts
- 4
- Registration date
- Wednesday August 1, 2018
- Last seen
- August 10, 2018
- Posts
- 2435
- Registration date
- Sunday September 12, 2010
- Status
Related:
- Macro to copy / paste cell text down various rows
- Macro to copy/paste specific range every 3 rows ✓ - Forum - Excel
- VBA copy/paste cells then drop 1 row for next ✓ - Forum - Excel
- Macro copy and paste in next blank cell ✓ - Forum - Excel
- Macro that goes to next blank cell [Solved] - Programming - Forum - Programming
- Macro to copy and paste cells based on criteria - How-To - Excel
4 replies
Thanks for the response but unfortunately it does not produce the result I need. Also, the format of my original note did not stay the same when I hit enter. Imagine this: Column A has the company names, Column B the employee's last names. Only the first employee in the list of 15 people indicates the name of the company and the remaining employees have a blank cell for their company name because it is easy to see who they work for since they're all together. My problem is that my list has over 50 companies and I would like to have an alphabetized list of all employees based on last name. If I sort the list as is - I have tons of people with no company name and I don't know who they work for. I need to be able to copy down the company names throughout my list so when I sort it by last name each individual has their company listed. Does this make more sense?
The process that I am using currently is this:
Double click the little black cross in the bottom right corner and the company name copies down to the next company name. So I am repeatedly doing this:
[END] [Down Arrow] [Double click copy cross]
[END] [Down Arrow] [Double click copy cross]
[END] [Down Arrow] [Double click copy cross]
[END] [Down Arrow] [Double click copy cross]
over and over and over....
I tried to create a macro but however the macro mimics the EXACT number of rows that were copied down instead of stopping when it reaches the next cell with text.
Thank you for taking the time to assist me!
Double click the little black cross in the bottom right corner and the company name copies down to the next company name. So I am repeatedly doing this:
[END] [Down Arrow] [Double click copy cross]
[END] [Down Arrow] [Double click copy cross]
[END] [Down Arrow] [Double click copy cross]
[END] [Down Arrow] [Double click copy cross]
over and over and over....
I tried to create a macro but however the macro mimics the EXACT number of rows that were copied down instead of stopping when it reaches the next cell with text.
Thank you for taking the time to assist me!
- Posts
- 2435
- Registration date
- Sunday September 12, 2010
- Status
Hi Debtiger,
Consider using this macro to do the task for you:
Best regards,
Trowa
Consider using this macro to do the task for you:
Sub RunMe()
Dim x, lRow As Long
lRow = Range("B1").End(xlDown).Row
For x = 2 To lRow
If Cells(x, 1) <> vbNullString Then
Cells(x, 1).Copy
Else
Cells(x, 1).PasteSpecial
End If
Next x
Application.CutCopyMode = False
End Sub
Best regards,
Trowa
TrowaD ~
I can't BEGIN to express how GRATEFUL I am to YOU!!!!!!!!!!!!!!!!!!!!!!!!!! Your VBA Code worked absolutely perfectly. I am blown away! I'm good with excel but not with code - and with the help of an online tutorial I was able to put your code to work. I have never posted an issue before and wasn't quite sure what to expect, but for a complete stranger to take the time to read all the details of my problem and spend their own time to work on a solution.... is a true indicator of the generous human spirit.
Thank you ever so much for your time and assistance.
I hope you have the most splendid day.
(insert the HAPPIEST emoticon here!)
Debra
I can't BEGIN to express how GRATEFUL I am to YOU!!!!!!!!!!!!!!!!!!!!!!!!!! Your VBA Code worked absolutely perfectly. I am blown away! I'm good with excel but not with code - and with the help of an online tutorial I was able to put your code to work. I have never posted an issue before and wasn't quite sure what to expect, but for a complete stranger to take the time to read all the details of my problem and spend their own time to work on a solution.... is a true indicator of the generous human spirit.
Thank you ever so much for your time and assistance.
I hope you have the most splendid day.
(insert the HAPPIEST emoticon here!)
Debra