I have very little experience with VBA and I am certain my question will have an easy answer.
I have seen posts related to mine and after trying about a dozen, I'm still having trouble. All I have been able to do is create a macro that when run, cuts and pastes the cells into a new worksheet, but it has issues with cutting too much, pasting over cells, etc.
I have a sheet (VancacyReport) that when a vacancy is filled, it is indicated in column Y by an "x." (I am open to better suggestions) and I want that entire row to be cut and pasted into the new sheet (Archive) starting in B:15.
If possible, I would like it to run automatically rather than using a hotkey every so often.
Any help will be much appreciated and I am open to any ideas that will work better than mine.
Thanks.
I have seen posts related to mine and after trying about a dozen, I'm still having trouble. All I have been able to do is create a macro that when run, cuts and pastes the cells into a new worksheet, but it has issues with cutting too much, pasting over cells, etc.
I have a sheet (VancacyReport) that when a vacancy is filled, it is indicated in column Y by an "x." (I am open to better suggestions) and I want that entire row to be cut and pasted into the new sheet (Archive) starting in B:15.
If possible, I would like it to run automatically rather than using a hotkey every so often.
Any help will be much appreciated and I am open to any ideas that will work better than mine.
Thanks.
