View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_3_] jeffhughes@ntlworld.com[_3_] is offline
external usenet poster
 
Posts: 10
Default help with automating saving spreadsheet on the click of a button

Bit more information

the cell formula would look something like this:

=TEXT(B7,0)&" - "&TEXT(E4,0)&" - "&TEXT(MONTH(B23),"MMMM")&"
"&TEXT(YEAR(B23),0)&" - Resource Request.xls"