Copy data from file to existing file to corresponding row and Column

[G.Bregvadze]

Working on project where one component of calculations requires:

1. When clicking some button to offer dialog windows asking which file to open
2. After choosing file: open the file
3. Copy data from Predefined sheet (in this case Summary sheet) from area with data (from Grey Cells (here starting point is always same Cell- E5, but the last raw and column should be found using may be raw count and column count?)
4. Paste in opened workbook (in the Summary sheet) in Grey area (based on column and raw values


The case is that the columns might be added, items also might be changed current file vs old, therefore the direct copy paste will not work and the copy of grey area should be match with column and raw values.


attaching the sample file for Copying the data and for pasting the data.