Forum Discussion
Rahul_SC
Helper IV
Helper IVAppend multiple workbooks by column position not by headers
Hi all, I have multiple excel workbooks which I want to consolidate. The problem is column headers are different and data type can also be different in multiple workbooks. However, I know the col...
You can just Demote Headers, then combine, nice and easy.
Rahul_SCHelper IV
Helper IVHi,
I did it as you suggested, but getting this error.
KT_Bsmart2gethe
Impactful Individual
Impactful IndividualHi Rahul_SC ,
Which step will it takes you to if you click on the "Go to Error"?
GetHdrs step:
You should expect something like this.
GetTbl Step:
You should expect something like this.
CombineHdrs2Tbls step:
You should expect something like this.
Once we are able to get it works, it should run it dynamically.
Regards
Kerwin