Select and copy an entire column with VBA in Excel
Select from the start to the end of the data with VBA. Determine where the data ends with VBA. Copy an entire column with VBA. Allow me teach you the skills in Excel that you need for business
Let me teach you the VBA that I have learn in my five years of consulting
Let’s take the frustration out of user forms
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
I use a Blue condenser Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Follow me on Facebook
Sub copycolumn()
Dim erow As Long
Worksheets(“Sheet2”).Select
erow = ActiveSheet.Cells(1, 1).CurrentRegion.Rows.Count + 1
Worksheets(“Sheet1”).Select
Worksheets(“Sheet1”).Range(“A2”).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy Sheets(“Sheet2”).Cells(erow, 1)
End Sub
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Nice video, but it is not working on the IF condition. I want to copy all the rows which have "NA" in Region column, but this one copy all the values down to end when it finds NA.
If want to copy columns as per headers name.
Thank you. Is there a way to run a macro on s selected range that is selected with your mouse?
Hi Barb, I have a bit of a task to solve and I am hoping you can help.
I need to take certain columns of data from 14 worksheets and compile it into one worksheet.
To complicate matters, the data from one worksheet needs to be "stacked". Let me try to explain:
Worksheet(1) copy columns DJ, R, DF, BR into Worksheet(15) – the data goes into A B C D
Worksheet(1) copy columns FQ, R, FN, DX into Worksheet(15)
Worksheet(1) copy columns HW, R, HS, GE into Worksheet(15)
Worksheet(1) copy columns KC, R, JY, IK into Worksheet(15)
Worksheet(2) copy columns DJ, R, DF, BR into Worksheet(15)
Worksheet(2) copy columns FQ, R, FN, DX into Worksheet(15)
Worksheet(2) copy columns HW, R, HS, GE into Worksheet(15)
Worksheet(2) copy columns KC, R, JY, IK into Worksheet(15)
Repeat 12 more times…
I hope this makes sense and that you can help keep me from performing 224 manual copy and pastes.
THANKS!!
Thanks it was very helpful simple and quick
If a cell is empty, there’s error.. is there a code that it will not be error even if the cell is empty?
Great. How can I copy columns A and B in Sheet 2, A and C in Sheet 3, A and D in Sheet 4? Thanks.
It's really great thanks teacher