I have few workbooks(X,Y,Z) with multiple sheets(a,b,c) and I need to extract few columns from one of the sheet(a) and merge these sheet(a) columns data to single sheet.
COLUMNS are static and dynamic
Static - these column names are same and present in all the sheet(a) of the workbooks(x,y,z) eg name, age etc
Dynamic - these columns are arranged by month like Jan, feb, mar, Apr in sheet(a) and like Jan, Apr, may in another sheet(a) of different workbook
These columns need to be extracted in a sorted order and consolidated to a new workbook
Name, age, Jan, feb,mar, Apr from sheet a of workbook x
Name, age, Jan, feb, mar, apr, may from sheet a of workbook y - feb and mar should be assigned value 0
My challenge is how do I extract months column data as they are different In some sheet but should be in sorted order like Jan till Dec in new workbook and assigned value 0 in case that month is missing for particular name
COLUMNS are static and dynamic
Static - these column names are same and present in all the sheet(a) of the workbooks(x,y,z) eg name, age etc
Dynamic - these columns are arranged by month like Jan, feb, mar, Apr in sheet(a) and like Jan, Apr, may in another sheet(a) of different workbook
These columns need to be extracted in a sorted order and consolidated to a new workbook
Name, age, Jan, feb,mar, Apr from sheet a of workbook x
Name, age, Jan, feb, mar, apr, may from sheet a of workbook y - feb and mar should be assigned value 0
My challenge is how do I extract months column data as they are different In some sheet but should be in sorted order like Jan till Dec in new workbook and assigned value 0 in case that month is missing for particular name