attachments.zipHi,
I have multiple workbooks, where data and Charts are placed in different tabs. Charts tab is common for all workbooks.
Requirement is to have new master workbook containing macro, which will fetch charts(input different cell ranges for each workbook) from *df* and *iostat* workbooks and paste them as images in master workbook, one below another.
Macro has should be flexible to add multiple workbooks.
If there is an input master workbook, containing input tab with following user inputs:
1) workbooks filename (based on this filename order, master file will have pasted chart images ordered)
2) file path
3) tab from where charts has to be fetched(in this case its always Charts tab)
4) Data Range Start Cell (this is ideally the range depending on number of charts in Charts tab)
5) Data Range End Cell (this is ideally the range depending on number of charts in Charts tab)
6) Copy To Sheet (Sheet in Master workbook)
7) CopyToLocation(Start Cell Only of sheet in Master workbook)
attached sample workbooks for reference.
thanks in advance,
Bookmarks