Hi
I need to link data between worksheets and was wondering if someone could point me in the right direction.
My Workbook pages look like this:
http://img444.imageshack.us/img444/5...ksheetstl2.jpg
When Data from the 'master' worksheet is updated, the workbook should update each daily worksheet.
Some sample data from the 'master' worksheet:
http://img152.imageshack.us/img152/6494/master1zk8.jpg
Now for example, if saturday's column (G3:G7 in the example) has data, then the saturday page should be updated to look like this:
http://img212.imageshack.us/img212/2350/dailyis0.jpg
(Range A3:E11 should be populated)
SO in summary, I need each daily worksheet to be populated if data exists in it's corresponding data in that days column on the 'master' worksheet. It should also check if the data is a number and if it's greater then zero.
Any help appreciated. Thanks in advance.
Bookmarks