I have this macro that finds a line of data that is annoted 'complete' and records the row of data in another worksheet called complete.
It works fine.
What I would like to do is once the line of data is transferred to the new sheet I would like the original line of data to be removed.
Can anyone help please
I tried to add a line to the macro but it didn't work
Thanks
Please Login or Register to view this content.
Last edited by scrumpyjack; 12-10-2017 at 10:50 AM.
Try changing the .Copy to .Cut
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thanks for the quick response
This is the line of code I entered
'Range(Target.Row).EntireRow.Delete'
Without it every thing works as it should. So why change 'copy' to 'cut' ?
Won't this effect the rest of the program?
Fred
Cut does the same as copy with one exception....after it pastes, the "cut" information is deleted, with "copy", the original information stays.
Without a sample of what you are working with, I can't say if it would effect the rest of the program or not.
Thanks that worked. See were you were coming from.
Right a relly basic excel question the sheet tabs at the bottom of the rotten workbook have disappeared and I can't get them back. Please tell me how
Thanks
Go to excel options (not sure how to get there with 2003)
Click Advanced
Scroll to Display options for this workbook
Make sure the box for Show sheet tabs is checked
Last edited by gmr4evr1; 12-10-2017 at 10:24 AM. Reason: Corrected typo
Hi scrumpyjack,
Please apply code tags to post #1 before we can proceed!
HTH
Regards, Jeff
Sorry about the code
Sorry but the sheet tab was already ticked
So the sheet tabs still are not showing.
Fred
Did they disappear after running the code with the .Cut option?
I don't think disappeared as such. Well to be honest I must have done something but it wasn't as a result of implementing the cut bit of code.
Fred,
Is it possible for you to attach the workbook....desensitized of course?
How do I do that?
Can I send it just to you?
In the window you are typing in, click the Image Icon (2 to the right of the Link [the one with the globe and chain] icon.
Click the From Computer tab
Click Basic Uploader (bottom right)
Click browse
Click the file you want to attach
Click Upload File(s)
The thing is it has personal details of clients etc and this can be seen.
I can't get into the main spread sheet as I cannot select sheets ie the sheet tabs are missing from the bottom of the page therefore not able to de-sensitised..
Can I email you the spread sheet?
Fred
Are you able to see the sheet(s), just not the tab(s)? If so, is it possible the other sheets are hidden or deleted?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks