Hi,
At the moment, I have this code:
What I want to do is change the formula so it copies the whole row, moves it to another sheet, but I want it so rather than delete the entire row, to only delete some of the cells in the same row.
Please Login or Register to view this content.
Is this possible to do?
I hope I have explained this clearly enough
Do you want to delete the source row but only some fields of it in the output row??
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
What I'm basically trying to do is copy a record from the properties sheet to the archive sheet, but want some fields like property address to NOT be deleted to save time typing them in again
You'll need to provide a "mask" for the fields to be retained.
How would I do that?
Just list the fields to be retained - "mask" doesn't mean anything special per se.
I get it, but how would the coding look to do this?
Perhaps something like this:
After the pasting we would just clear the contents of the columns to be "deleted"
'Please Login or Register to view this content.
thanks
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks