Hi,
I am trying to create a tracker for work.
The job we are doing has got multiple operations. I have listed the operations in Cell A1 to L1.
Under each operation serial numbers are listed.
I would like a macro button that moves the active cell to next free cell in the next column (next operation) and then sort the numbers.
Hope this makes sense.
Chris
By 'move' do you mean cut and paste or just copy and paste?Originally Posted by chris1896
Which numbers? Columns? Rows? Range?
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
I mean cut and paste. Let say I have got numbers from A2 to A30 and I want to cut A7 into the next free cell in column B. I might also have something in C17 and want to cut and past it into column D
Could you post a workbook with an example of before and after?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
that would be easy enough.
But what about the sort?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks