I would like to know the best way to extract data form multiple workbooks in to one single workbook.
E.g.
workbook 1 = Named range = R1
workbook 2 = Named range = R2
In workbook 3 I would like to copy R1 and R2 one below the other and create range R3 or create a live link so that I can analyse the data using pivot tables.
Currently I have copied links from R1 and R2 to make named range R3.
Is there a better way of doing this using VBA.
I would very much appreciate any comments.
Thanks,
Rennie