Transfering auto data from workbook1 to workbook2

[RJ1969]

Hello,

Is there a vba code that will work to copy or transfer whatever works that I do in the other workbook.

Let say I am working in WORKBOOK1 and doing like setting the columns, adjusting the cells and entering datas THAT will do or automatically the same in workbook2.

So the vba code will be in workbook2.

Instead me putting the formula in every cells in workbook2, I rather have the vba code which I think it will be simple.
This is the formula i used in every single cells in the workbook which so tedious to do in every cells.

Please Login or Register  to view this content.

I just hope there is a way.

Thank you in advance!

[Marc L]

Hello,

no, the reason why Excel templates exist so you just have to create one.

Another way : use the Macro Recorder …

[RJ1969]

Ok. thank you.