I would appreciate an assist with vba code that moves adjacent cells from one sheet to another. The loop will be based on a DV selection: Next, None or Completed. The DV column will reside in all sheets at “A”. As the data moves through the work process move (not copy) data is collected and the number of adjacent cells grows. It will need to find the last row in the new tab to paste to. Thank you for your expertise and time.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Move expanding selection of cells to new tabs based on condition
- Thread starter LeeLee17
- Start date
since column A is being used to direct to move data, I am guessing that may not always have values in it. So I used column B. That can easily be changed, if there is a better column to use.- This is interesting because theoretically there will be times when there is nothing in a particular process but the headers...
Upvote
0
If we wanted to get really clever, we could even pass in the destination sheet name as a parameter, so you could re-use this code for all your moves. You would still need a small procedure attached to each button telling it which values to pass. Clever is always intriguing, what other info so you need from me?
Upvote
0
Excel Facts
Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
It works brilliantly! It moves the data along the process perfectly! It is so clear that I was able to modify to copy from the initial tab and to the last tab as needed. I can't thank you enough for generously sharing your time and expertise. Thank you for making a difference for our new LO. Best.
Upvote
0
