what do the macros do in the .xlsm workbook?

It would help if you could post samples of both workbooks.

Regards