Hello,

With the help of many people in this forum and some other research (aka Dr Google ) I have managed to get a reasonable level of knowledge in how to deal with "lots of problems" in a single workbook containing many worksheets. I am happy (and actually quite chuffed) to admit that I have even gained "rep points" for assisting many others as well.

Sadly I think my current issue is beyond my current knowledge level.

My problem, from a business perspective, is that I have a workbook (say "2014 financials") that has many worksheets which apart from a couple of special sheets are all identical in format. In that workbook I am building a macro that will cycle through the worksheets, sending an email with a data range included in the body of that email, perform a couple of "updates and save the worksheet.

So far, all relatively easy, under control, and working, mimicking existing processes in other workbooks I have built.

What I need to master is how to, from within my macro, "open another known workbook, navigate to a specific summary page (say "property register"), perform a filter and copy action and then go back to my primary macro and past the "copy data" into a known spot that I can then process "normally"

My current workbooks (the two I am trying to use) have some confidential data in them so I cannot post them right now. I am trying to get a sensible sample set of workbooks created but was just wondering if this is indeed a simple problem that many have working examples of already.

Thanks

Jmac