button macro for updating help needed

[Duffer]

Hi ,
I am still trying to get this sheet working , what i need to do is use a macro with a button to activate it to copy cells c18 to e36 to cells bj22 to bl41 , i don't know how to do the macro and need help .

Duffer .

 

[Nebu]

Hi

Please find the attached.

 

[Duffer]

Hi

Please find the attached.

Hi Nebu ,
Thank you for doing this you have made an old Duffer happy ,

Regards , Duffer .

 

[Duffer]

Hi ,
Is there an easy way to save a spreadsheet with a macro and xlsm extension ??

Duffer

 

[Nebu]

you can record a macro to do this

 

[Duffer]

Hello Again Nebu ,
Could you give me example of a macro to save the spreadsheet please or put it into the attached spreadsheet ,

Regards , Duffer .

 

[Nebu]

Hi:

Do you want to do a save or save as , if it is just save u do not need a macro. Can you explain more what you want to achieve here , if the excel is having a in-built functionality it is better to use it rather than writing a macro...

Thanks
Nebu

 

[Duffer]

Thanks again Nebu ,
I would like to save and then when wanting to open it with everything intact , so i guess just save ,
Cheers , Duffer .

 

[Nebu]

Then you can use the default save function , just save your workbook as macro enabled workbook and enable the content whenever you open the workbook to run the macro

 

[Duffer]

Then you can use the default save function , just save your workbook as macro enabled workbook and enable the content whenever you open the workbook to run the macro

Thanks Nebu ,
i just save and close and when i reopen the spreadsheet everything is ok , so far
.
Regards , Duffer .