Click on an item and it copies it to another separate workbook

maggot30 Posts 1 Registration date Monday March 30, 2015 Status Member Last seen March 30, 2015 - Mar 30, 2015 at 07:59 PM
Hi there,

I have two catalogues that I have to use to purchase equipment, They are on different workbooks. To save time I was wondering if there was anyway that i could click on an item and somehow it copies it to another separate work book. copying and pasting takes up so many hours and I need a more efficient way to do things.

I know it sounds a bit far fetched but who knows what you can achieve these days.