Dear Sir,
I need to merge excel worksheets from multiple files in a single excel (master) file accordingly to
their worksheet name.
- If the worksheet already exists in the master file then it will insert (merge) data / rows below to
existing data row in the master sheet or if not exist then will create new sheet and insert data as per
source file rows. (its mean that Master file should have all sheets by data wise which all source sheet
files have)
= It will not analysis /compare column title / header, but will
- unhide all rows and column, copy and Paste Special Value from 1st row / column till end (row by row)
from the source file to available lower cells of Master File like a manual task.
- Delete blank rows, unhide all rows and column of the source file before copy.
- While inserting each row, It will add file name in the first column. (similar to Microsoft Power
Query).
- There should have “Check” with number select option for how many rows escape from up / start from all
source sheets (which is always “Header row / title”) while copy and pasting in the master file from
source data.
In short, simple and with only one above option, it should work as a manual system. Just copy from one
sheet to master sheet without compare / any analyzing work.
Hope you will help me to give a solution in this regard.
Regards,
Ali Khan
I need to merge excel worksheets from multiple files in a single excel (master) file accordingly to
their worksheet name.
- If the worksheet already exists in the master file then it will insert (merge) data / rows below to
existing data row in the master sheet or if not exist then will create new sheet and insert data as per
source file rows. (its mean that Master file should have all sheets by data wise which all source sheet
files have)
= It will not analysis /compare column title / header, but will
- unhide all rows and column, copy and Paste Special Value from 1st row / column till end (row by row)
from the source file to available lower cells of Master File like a manual task.
- Delete blank rows, unhide all rows and column of the source file before copy.
- While inserting each row, It will add file name in the first column. (similar to Microsoft Power
Query).
- There should have “Check” with number select option for how many rows escape from up / start from all
source sheets (which is always “Header row / title”) while copy and pasting in the master file from
source data.
In short, simple and with only one above option, it should work as a manual system. Just copy from one
sheet to master sheet without compare / any analyzing work.
Hope you will help me to give a solution in this regard.
Regards,
Ali Khan
Last edited by a moderator:
