Sorry that should have said - Automatically transfer data from one workbook to another workbook.
Hi Guys, I have only been getting my head around these more advance parts of excel for a few weeks so please excuse my ignorance when it comes to more advanced things but I have a problem question.
I have 2 different workbooks. 1 is called "records" the other is called "results".
I receive the "results" workbook every morning by email, I have the "records" workbook on my PC and cloud storage. I was wondering if it was at all possible that I could after downloading the "results" workbook which is of the previous days work, have it so that I do not have to go through it an manually add each and every value from each cell?
In the workbook "results" in column F are a list of names some of these names are also in the "records" workbook in column C. In column H of the "results" workbook is the first value I would like to see in the workbook "records", I would like it if possible if "records" could search workbook "results" column F and when it finds the corresponding name then the value from "results" column H is shown in "records" column AZ. I would also like the same to happen with "records" column M being show in "results" Column BB.
I have no idea if this is all far too complicated but it would save me an awful lot of tedious work and I would be very grateful for any advice/help/input.
Bookmarks