• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If cell = X copy to. relevant sheet

Kurt Smart
Did You read my previous (#24) Reply; from the 1st to the last line?
Ex You asked to 'copy&paste&clear-pasted-away' some ranges ... it do so!
That's move! If 'copy&paste' then there were two times same data!
Now, I changed that it 'copy' and 'paste only values' .. it's different!
... and if previous happen then it clears 'copy range' as You wanted.
... clear means 'clear' = all-away = delete that range!
... and You missed, in the beginning, one point too - You're using a table!
> What would someone do with Your the newest file?
I uploaded my 'paste special'-version.
 

Attachments

  • Goods In - KPI (2).xlsb
    161.7 KB · Views: 9
Back
Top