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.
Click on an item and it copies it to another separate workbook