Remove Source Data from Output resulting in same worksheet

[macrolearnerkk]

Please review the following thread for source information and required output

http://www.excelforum.com/excel-prog...onditions.html


Source Data is preent in worksheet1

Output data should be reflected in same worksheet worksheet1 by removing all the source data.

Source data is present in thousands of rows, following the patterns as indicated in the above link.

I appreciate your help in advance. Thank you for your time and support.


KK

[macrolearnerkk]

http://www.excelforum.com/excel-prog...rce-sheet.html

http://www.excelforum.com/excel-prog...onditions.html

[Doc.AElstein]

Hi
. The original code I did for you
http://www.excelforum.com/excel-prog...ml#post4182685
produces your output in an Array before pasting that out to sheet 2.
.
. So the code would be very easily modified to do I think what you want.
. If I understand correctly you just want to copy the output to the input sheet having removed all the input first?
. In which case you simply add a line before the my line which outputs to sheet 2 which clears the input sheet.
. Then simply modify the line in my code which pastes to the output sheet so that it pastes to the input sheet
. Possibly I have misunderstood by your referencing to different threads
Alan

P.s.
I was still a bit puzzled from no feedback from you on some codes done for you ?

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.