Copy range from hidden sheet to active sheet if cell ="Some text"

[pjbassdc]

Hi all,

Been looking for, and working on a macro to copy a range of cells from a hidden sheet and pasting the selection into the active sheet if cell D2="MEP"

I have been working myself in circles and finding all sorts of ideas to try, however, nothing as worked out at this time. I have been getting a variety of errors, try something different, error again.....repeat.

Here is the bit that I have. I realize it is a bit of a "hot mess", but I am still learning :-) Active sheet is "Form", "Data" is hidden but not very hidden.

Please Login or Register  to view this content.

Your help is greatly appreaciated.

Patrick

[pjbassdc]

Nevermind. I figured it out. Not the way I really wanted it, but in the end it works.

[arlu1201]

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.