Fyresparxx
New Member
- Joined
- Mar 21, 2014
- Messages
- 18
I have a workbook that has two sheets. Sheet one is in color and there are six timecards on it that all fit on one screen. Sheet 2 has those same six time cards, organized vertically instead of horizontally, and all the color formatting has been removed for printing. The idea is that everyone fills their card out on page one, and the sheet can be printed from page two. Printing page 1 with fit to page makes it too difficult to read. Each card is identical in every way, using copy/paste and format painter. Page 2 uses a bunch of IF formulas to transfer data from page 1 to two, leaving blank blocks blank.
My problem is that on page two, I'm using the following formula to transfer a "notes" block for employee A.
=IF('Enter Timecards'!C14:J15=0,"",'Enter Timecards'!C14:J15)
And I'm using this one for employee B.
=IF('Enter Timecards'!Y14:AF15=0,"",'Enter Timecards'!Y14:AF15)
Employee A works as intended. Employee B gives me a Value error. I don't understand why this is happening.
My problem is that on page two, I'm using the following formula to transfer a "notes" block for employee A.
=IF('Enter Timecards'!C14:J15=0,"",'Enter Timecards'!C14:J15)
And I'm using this one for employee B.
=IF('Enter Timecards'!Y14:AF15=0,"",'Enter Timecards'!Y14:AF15)
Employee A works as intended. Employee B gives me a Value error. I don't understand why this is happening.