Dear Geniuses,
Is there a way to import a graph from a certain workbook and specific sheet into a main summary sheet if a cell matches the workbook name.
That's to say, the sub or macro will be assigned to a specific cell (say A10) so that a graph is copied from another book which is named same as the text in another cell (say A1) and pasted as image or chart....
---------
We have Book 1 and Book 2
in book 1 cell A10 a graph will be imported from book2 sheet 1 if A1=book2 ( I do not know id chart cab also be referred to as range of cells)
Thank you in advance,
M.
Bookmarks