leave cells blank without zeros

Guys i have a mock up football issue here i want to enter scores in sheet 1 and they automatically fill sheet 2 etc i know i can just =and copy sheet 1 A5 and so so but that leaves zeros which will start allmy formulas with 1 point i need a formula that will leave sheet 2 3 etc blank untill any score is entered

Cheers

I'm confused. If you're going to maintain identical sheets to represent scores from identical matches on different days/weeks, why aren't you entering the values directly into the sheet it belongs in? That's the simplest and precludes needing to do anything funky with formulas and macros.

==========

If you're going to have multiple identical sheets and you want Sheet1 to flow to one sheet one week and another sheet a different week (without week1 losing its already received scores), I imagine:

1) Do all the work on Sheet1 with no "flowing" at all, then copy the finished sheet to the end of the workbook to act as the weekly sheet. Then clear sheet1 again for the new week.

2) Flow the scores to a specific sheet each weekl, then remove the formulas:

a) Name the sheets for the weeks (week1, week2, week3, etc).
b) Add a cell on sheet1 that indicates which week is being entered (A1 = "week1").
c) Add a cell on each weekly sheet with this formula in it:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
(causes the sheetname to appear in A1)
d) Starting in B5, the formulas in the sheets would be something like:
=IF(Current!$A$1=$A$1,IF(NOT(ISBLANK(Current!B5)),Current!B5,""), "")
(Copied down and across, then to all sheets)

These sheets would stay empty until the sheet1 A1 cell matches their A1 cell, and the values in the chart on Sheet1 are greater than "empty", then they would display a value.

NOTE: Before starting each week, you will need to go to the current week and remove the formulas with a copy/edit/pastespecial/Values on the chart, else the values will disappear when you start the next week. I imagine a little macro can do this for you, but it's simple to do manually.

Ah, great, glad we could help.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)