Hi, I have upgraded to MS Excel for Mac 2016, prior to this I was using MS Excel for Mac 2011.

Previously I was able to select the data I needed, and then at the press of a couple of keys it pasted from WB1 (Master invoice) to the correct location in WB2 (Customer Invoice). These are separate documents.

The two work books are (WB1) Master Invoice which contain calculations I use for invoicing our customers and (WB2) a Customer Invoice where the Values are pasted. WB2 is then emailed as a PDF.

I was using a macro which worked fine in the 2011 version but since upgrading it doesn’t work at all.



When I try now to set up a new Macro it doesn’t record the fact I have stepped from one work book to another, its like it isn’t even there. I’ve tried to suss out the file name and add it manually but without luck.

I am aware that I could put the invoice in the Master Invoice workbook but for privacy concerns i’d be worried that there was a way to unpick the PDF revealing other peoples accounts.

Can anyone help please with what should be a simple Macro.

Without seeing the code you say no longer works, it's impossible to advise what the issues might be. As for:that would not be possible; PDFs are rather like printout sent to a printer - no-one can see (or access) what isn't included.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]