Macro to bring cell content from one of the other open excel files.
Posted on 2011-02-28
understand this could be a bit hard to do.
I am working with worbook A-sheet"Figures" and want to trigger a macro that:
1) asks from which of the opened excel files at the time I want to bring the data into this workbook, ideally I just select from a drop down list.
2) It ALWAYS brings the data from the selected work book from Sheet called "YTD" and from cells A1:C30, copies and pastes it into my workbook A-sheet"Figures" on cell B5 (in other words B5:D34).