I have users that copy cells from a source sheet (sometimes hidden columns) and paste to another sheet (different workbooks usually).
Sometimes the destination sheet will contain hidden columns (not necessarily the same hiddden columns configuration as the source).
I would like to have an event in the destination sheet to paste the source visible cells values only to the visible cells in the destination sheet.
So what you see (visible cell values in the source) is what you get (values in visible cells) in the destination sheet.
So as not to corrupt/overwrite destination cell formats & validation, and have source values paste into hidden destination cells.
Any assistance would be appreciated
Bookmarks