I get a daily sales workbook from my various stores showing various data. Each workbook contains several worksheets from Day 1 to Day 30. How do I sum up the various data across the worksheets without having to do manually =SUM(Worksheet1 Reference + Worksheet2 Reference + ....). All the fields are common across the various worksheets, only values differ due to various sales amounts.
thanks,
ashwin
thanks,
ashwin