otamaglimmer
New Member
- Joined
- Nov 25, 2019
- Messages
- 5
- Office Version
- 365
- 2016
- Platform
- Windows
Hello there!
I've been working with a table and struggling to find or make a script that would move an entire row from the first sheet of my book (let's call this sheet "NEW") to a second sheet ("OLD") when I change the background color of that row to red. Table's width is A to J and the first row is a header. It would be fine to just compare the last cell color.
It should copy this entire row to the first empty space in that second sheet, and delete the entry from the first one.
Additionally I would love to do the same but to a different sheet when a given cell of that table (cell in column J) is turned blue.
I'm completely new to VBS and I'm getting lost here...
Any kind of help would be much appreciated!
Thanks in advance!
I've been working with a table and struggling to find or make a script that would move an entire row from the first sheet of my book (let's call this sheet "NEW") to a second sheet ("OLD") when I change the background color of that row to red. Table's width is A to J and the first row is a header. It would be fine to just compare the last cell color.
It should copy this entire row to the first empty space in that second sheet, and delete the entry from the first one.
Additionally I would love to do the same but to a different sheet when a given cell of that table (cell in column J) is turned blue.
I'm completely new to VBS and I'm getting lost here...
Any kind of help would be much appreciated!
Thanks in advance!