Copy Column Data to another sheet

[joshag]

I have researched this to death and I am trying to do it "down and dirty" but with little success. I need to copy the column data (text) from one sheet to another without copying the entire column. I need the contents of "E" on one sheet to fill column "A" on another sheet. I have tried many variations without any success. Probably my shortcut approach.

Any help is always appreciated.

Sheets("List").Range("A" & Rows.Count).End(xlDown).Value = Sheets("Main").Range("E" & Rows.Count).End(xlDown).Value

[JOHN H. DAVIS]

Can you attach a sample sheets showing before and after?

[alansidman]

Maybe this:

Please Login or Register  to view this content.

[joshag]

Sorry John, I guess I could spend some time making up fake data and names but I am working off of a sheet that contains client names and info that I can guarantee no one wants to see public!

[joshag]

Well I guess in this case Alan is d man. Worked as advertised and I thank you! My lack of knowledge in vba (and age) holds me back so I always try and shortcut. It definitely is not the easy way for me but it works and that's all that counts.
My employer benefits from my work but sees no advantage to sending me to any continuing education for it.