Hi,

I hope i am posting in the correct forum.

I am trying to get the following and was wondering if anyone can help me on this as i am a noob with VBA but think it may be my only option.

We have a workbook that holds all revenue figures for the month, and we add values for each sale made, this workbook is made up of several worksheets that are saved down as single web pages at the end of the day into the relevant team folders on the network. What i would like to do is have the workbook automatically save each of these sheets into their relevant folders and in the correct format each time the book is saved or updated. Is this a simple code or is it quite complicated?

Thanks in advance.
Dan Lake.