VBA to copy down text in a column
I have to copy down text in a column, but there is a catch!
I can't just copy down until there is text in cell because that won't work with the very last item in the column. I need to copy Column B until there is a non-blank cell in column A!
After those are done, I can copy down text until the next non-empty cell in column A.
Can anyone help me with the VBA for this!?
I uploaded a sample file - THANK YOU!! :)
Book1.xlsx
I can't just copy down until there is text in cell because that won't work with the very last item in the column. I need to copy Column B until there is a non-blank cell in column A!
After those are done, I can copy down text until the next non-empty cell in column A.
Can anyone help me with the VBA for this!?
I uploaded a sample file - THANK YOU!! :)
Book1.xlsx
Last Comment
Martin Liss
Is Sheet1 the result that you want?
ASKER
Hi, Martin!
I put both the start and the end on sheet 1.
It will originally look like the data in columns A & B
But should end up like the columns to the right.
Thanks so much!
I put both the start and the end on sheet 1.
It will originally look like the data in columns A & B
But should end up like the columns to the right.
Thanks so much!
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
lad I could help and thanks for the Testimonial.
Could also do with 2 simple formulas.
In spare columns, eg K and L enter these formulas:
K2 =IF(A2="",K1,A2)
L2 =IF(B2="",L1,B2)
Copy down as far as required and then copy and paste values into the original range.
In spare columns, eg K and L enter these formulas:
K2 =IF(A2="",K1,A2)
L2 =IF(B2="",L1,B2)
Copy down as far as required and then copy and paste values into the original range.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
