vba help

[Valentin]

Can anyone write this code for me
Generate new workbook from active workbook with the same amount of visible sheets and the same sheetnames as the active workbook
In the new workbook on every sheet generate reference to cells A1 A2 A3 C1 C2 to corresponding sheet of active workbook

 

[Smitty]

You can easily get the first part by recording a macro performing a Save As.

For the second part, you can open the first workbook again, then record a macro linking the sheets, then combine the code.

Recording this is important because VBA will capture the correct file names/paths.

Post back what you get and someone can clean it up for you.