stagecrazy
New Member
- Joined
- Aug 9, 2011
- Messages
- 1
I have a 2 week schedule worksheet.
Employee, date, time in, time out, total hours for 11 people.
I made a HLOOKUP in which the table array is from an separate workbook (may master calendar). $A$1:$CZ$50
But when I work in my MASTER CALENDAR and delete columns, the table array size in the schedule worksheet GETS SMALLER.
Is there a way to keep its size at 100 col x 50 rows (for example) REGARDLESS of whether I delete or add columns/rows?
Employee, date, time in, time out, total hours for 11 people.
I made a HLOOKUP in which the table array is from an separate workbook (may master calendar). $A$1:$CZ$50
But when I work in my MASTER CALENDAR and delete columns, the table array size in the schedule worksheet GETS SMALLER.
Is there a way to keep its size at 100 col x 50 rows (for example) REGARDLESS of whether I delete or add columns/rows?
