hostelowner
Board Regular
- Joined
- Apr 19, 2005
- Messages
- 105
Master worksheet showing a list of consolidated data , specifically daily sales ranging from first of the month to last day of the month. Master worksheet Column A has dates, Column B has cash totals, column C has Credit card totals. Column B and C ref sales totals pulled from different worksheets and workbooks.
The way I have my files organized is straight forwards - Sales/year/month/day.
Each Folder holds a workbook for each day of the month, each folder is titled after each month of the year, etc Sales folder holds 2012 sales folder with monthly sales folder containing daily sales workbooks and I specifically need to pull cells E46 and E48 to the master list.
Each workbook has the same titled worksheet name "control caja" this is consistent for every workbook.
Master worksheet example....
.........A....... B ............C
.....date .....cash...... card
1)1.1.2012... 200....... 400
2)1.2.2012... 100....... 200
3)etc...
hope this is enough information
regards
mark
The way I have my files organized is straight forwards - Sales/year/month/day.
Each Folder holds a workbook for each day of the month, each folder is titled after each month of the year, etc Sales folder holds 2012 sales folder with monthly sales folder containing daily sales workbooks and I specifically need to pull cells E46 and E48 to the master list.
Each workbook has the same titled worksheet name "control caja" this is consistent for every workbook.
Master worksheet example....
.........A....... B ............C
.....date .....cash...... card
1)1.1.2012... 200....... 400
2)1.2.2012... 100....... 200
3)etc...
hope this is enough information
regards
mark
Last edited:
