Need help moving Rows

[sleevedfreak]

So i tried to use the information in this post to solve my issue as it was really similar. @vletm Had provided some great data. But I cannot get it to work in my sheet.

How to move any row from a Table to a Sheet?

Hello everyone, I was wondering if it is possible to move any row (it mustn't necessarily be the first or the last one) from a table to another sheet. If it is, I would appreciate to learn how to do it, with your help. I attached for you an example I made: I'd like to be able to move any row...

chandoo.org

attached is a stripped-down version of what I have. In my file I am using Sheet 1 is "Data" and Sheet 2 is "completed. Basic information is when the Delivery gate is changed to published I want the information in that row to move to the completed Sheet.

 

[vletm]

sleevedfreak
Your attached a stripped-down version file misses many headers (1st row) from both sheets.
... with those - it would be possible that my sample code could work with Your 'move'.

 

[sleevedfreak]

sleevedfreak
Your attached a stripped-down version file misses many headers (1st row) from both sheets.
... with those - it would be possible that my sample code could work with Your 'move'.

I added headers in today and tried again, it is not working, most likely a user error. When I have more time I will try again to get this working.

Thanks

 

[vletm]

sleevedfreak
It's not working ... it needs to do more modifications.
Your thread is different than that other thread.
You've written that row will move at once, user has changed Delivery gate to 'published'.
One sample.

 

[sleevedfreak]

I got it to work on my test sheet then when I put it into the full workbook I received this error.

 

[vletm]

sleevedfreak
Your the full workbook has something different than Your test sheet or my sample file.
I won't start guessing without seeing it.

 

[sleevedfreak]

sleevedfreak
Your the full workbook has something different than Your test sheet or my sample file.
I won't start guessing without seeing it.

Understand, I will try to get a copy without the data that I cannot share. my full workbook is heavily filtered but the test workbook is not.

thanks again

 

[vletm]

sleevedfreak
So far my coded file do not have any filtering.
What else do Your attached a stripped-down version file misses?
A sample file should be as used version with sample data.

 

[sleevedfreak]

@vletm Sorry it took me a while! I think even though this is a better stripped down sheet. If I cannot get it to work, I might just give up and cut and paste!!

Thanks again

 

[vletm]

sleevedfreak
#1 Your TEST COPY.xlsm's sheets has different layouts
eg Your original AutoMove-files Sheet1 has AB-column that column - where You should change something to "Published"
... TEST COPY's Data-sheet's AB-column seems to be for some other use >>> Cannot work
#2 TEST COPY.xlsm has for some reason same code in many time - most of 'codes' cannot work at all.
#3 Should I somewhere found those heavily filtered --- which You mentioned?

If You've changed layout then there should do needed modifications with code too.
Did You send a correct file?