AndrewRossington
Board Regular
- Joined
- Oct 27, 2005
- Messages
- 114
Don't be mislead... I don't even know if such a thing exists.
I'd like it to exist.
Basically what I have is a pre-formatted sheet (sheet 1) that allows for data entry at certain points on the sheet, only if corresponding cells on another sheet (sheet 2) meet a certain criteria.
I'd like to be able to set it so that:
If the first 5 cells on sheet 2 meet the criteria, then the first 5 entries on sheet 1 will be printed when print is clicked. If only the first cell on sheet 2 meets the criteria, then the first entry of sheet 1 will print, but no more.
Additionally..... if the 3rd cell on sheet 2 meets the criteria, but cells 1, 2, 4 and 5 do not, then the 3rd entry point on sheet 1 will print but not the 1st, 2nd, 4th or 5th.
I'd like it to exist.
Basically what I have is a pre-formatted sheet (sheet 1) that allows for data entry at certain points on the sheet, only if corresponding cells on another sheet (sheet 2) meet a certain criteria.
I'd like to be able to set it so that:
If the first 5 cells on sheet 2 meet the criteria, then the first 5 entries on sheet 1 will be printed when print is clicked. If only the first cell on sheet 2 meets the criteria, then the first entry of sheet 1 will print, but no more.
Additionally..... if the 3rd cell on sheet 2 meets the criteria, but cells 1, 2, 4 and 5 do not, then the 3rd entry point on sheet 1 will print but not the 1st, 2nd, 4th or 5th.