Hey Everyone,
Wondering if anyone can help me with my question. This is for Excel 2010, work related.
I have 2 excels which i use. 1. Customer 2. Info.
Basically i want something where i can open Customer excel and press a button to open file explorer to select the info excel and copy X columns from that and paste into the customer excel. At the moment i am manually copy and pasting the column from info to customer and I am sure there a easy way to do it. Info excel has multiple sheets i have to copy from.
Many Thanks,
Wondering if anyone can help me with my question. This is for Excel 2010, work related.
I have 2 excels which i use. 1. Customer 2. Info.
Basically i want something where i can open Customer excel and press a button to open file explorer to select the info excel and copy X columns from that and paste into the customer excel. At the moment i am manually copy and pasting the column from info to customer and I am sure there a easy way to do it. Info excel has multiple sheets i have to copy from.
Many Thanks,