Hopefully one of you awesome excel experts can help...
I have to create a userform with Commandbutton to navigate on (Get workbook path) selecting the "Abc" excel workbook, it should copy with all the sheets that are available in "Abc" workbook and paste that in different path as...
Need a Macro where i have workbooks with 5 sheets. with sheets having different column headeres.
Similary i have the workbooks with 5 users.
currently i have to merge all the 5 workbooks with 5 sheets.
I have multiple excel workbook ( 85) in one folder. Each workbook contain 13 sheets has same names with different order. Only Excel workbook name is different. Now I want to assign all workbook sheets in one order. Kindly note Its not assent or dissenting order. I had listed all...
Fluff you provided code to copy the contents of worksheets beyond the Summary worksheet. This works phenomenally however it is bringing in a formula and I was curious if I could just get it to copy the values.
The other thread has the same title w/o pt 2