Hotel daily sheet

**Anil11** · 12-14-2012, 02:06 AM

I have a workbook which consist of worksheets for each day of the month. Example of name of sheet: 01-Jan 2012 and so on for each day of Jan. I have a total daily sales cell that I want to copy to a monthly total sheet in the workbook. The monthly total sheet have 1 column with the name of sheet ex: 01-Jan 2012 to 31 Jan 2012. So basically need a macro for monthly total sheet to go each worksheet and get total from cell f39.

**FDibbins** · 12-14-2012, 02:28 AM

Anil welcome to the forum

however, i would ask that you please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it of interest to them, or falls within their area of expertise, and will only open those threads. also, searching for "help" will not turn up too many results that will benefit you, sorry

**Moo the Dog** · 12-14-2012, 02:36 AM

Try this:

Please Login or Register  to view this content.

Must make sure the sheet name "01-Jan-2012 to 31-Jan-2012" exists and that it is the first sheet in the workbook.

- Moo

@FDibbins: Oops! Sorry. Didn't see your post before submitting this...

**Anil11** · 12-14-2012, 12:36 PM

Thanks for suggestion

**Anil11** · 12-14-2012, 12:38 PM

Thanks this is what I was looking for

**Moo the Dog** · 12-14-2012, 12:43 PM

Glad to help.

- Moo

-------------------
If my proposed solution(s) have helped, please click on the star at the lower-left corner of one of my posts. Feedback is ALWAYS appreciated.