I frequently have to copy a cell down a column to the last row in the worksheet. Auto filling works fine if the column to the left has data in every cell, but this is often not the case. I need a macro which will allow me to select a column which I know to have data in ever cell and then copy data in the active cell to the last row.
ElsiePOA
Try this:
Please Login or Register to view this content.
Not a macro but If you know the column try hiding the others. Just rember to unhide once done. Read this in another Excel forum I read
Worked great. The only thing that would improve it is if the macro asked user to select the column you know has data in every cell to the last row
That flow makes no sense. You can either select a column or an active cell like you said in your first post. Not both. You can input a column into an input box if you want which would be easy to code in.The only thing that would improve it is if the macro asked user to select the column you know has data in every cell to the last row
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks