Hi All,
How can I copy non empty values in a column and paste it into another column in another sheet using vba.
For example I have data in column C in sheet1 and I want to celect non empty cells from C5 downwards and paste it to column A sheet2.
Thanks,
Try:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Autofilter on non-empty cells and copy Visible range.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
thanks Oily. It gives an error "Object required"
Any idea how can I get rid of that?
Originally Posted by Olly
Try:
Please Login or Register to view this content.
Check the codenames of the worksheets you are actually trying to reference.
Try something like this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks