Email the changed rows from a multi sheet workbook as an attachment?

[gcmax]

Hello,

I have been looking for a solution to this but haven't got very far: at the moment I can email the whole workbook but need to just see what was changed since the last save. Is this possible?

Many thanks

 

[sijpie]

Unless 'Track Changes' is on, or you have the previous version as a reference, then no.

 

[gcmax]

Hi sijpie,

Track changes seems like the answer to my worries. I wish I had known about this being a built in function to excel before.

Thanks for helping

 

[gcmax]

Hello again,

I experimented with the track changes options and really they are not helpful. The history sheet which contains all the changes disappears after save, then you have to re-enable the option to save to a separate sheet the next time anything is altered

Why Microsoft did this is totally beyond me as it is counter productive.

So it looks like I'm back to square one.