Hello,
I have 'inherited' a workbook which has been tampered with in some way and no longer works properly.
I have to fix it, but sadly I am getting nowhere. I would be grateful for any help!
The front sheet is a work schedule. Rows from this are supposed to be copied onto two other sheets, depending on a) which name is identified and b) the urgency of the task.
The main formula used throughout is
=IF(ISERR(INDEX(Schedule!$I$23:$I$125,SMALL(IF(Schedule!$I$23:$I$125="Important",ROW(Schedule!$I$23:$I$125),306),ROW()-ROW($I$4)+1)-ROW($I$4)+1)),"",INDEX(Schedule!C$23:C$101,SMALL(IF(Schedule!$I$23:$I$125="Important",ROW(Schedule!$I$23:$I$125),306),ROW()-ROW($I$4)+1)-ROW($I$4)+1))
When the schedule was full, data was not being copied or was transferred to the wrong sheet.
I deleted most of the entries in order to start again but have found that my entries are not being copied or are returning nil/zeros
I am lost!
Any suggestions?
Thank you
I have 'inherited' a workbook which has been tampered with in some way and no longer works properly.
I have to fix it, but sadly I am getting nowhere. I would be grateful for any help!
The front sheet is a work schedule. Rows from this are supposed to be copied onto two other sheets, depending on a) which name is identified and b) the urgency of the task.
The main formula used throughout is
=IF(ISERR(INDEX(Schedule!$I$23:$I$125,SMALL(IF(Schedule!$I$23:$I$125="Important",ROW(Schedule!$I$23:$I$125),306),ROW()-ROW($I$4)+1)-ROW($I$4)+1)),"",INDEX(Schedule!C$23:C$101,SMALL(IF(Schedule!$I$23:$I$125="Important",ROW(Schedule!$I$23:$I$125),306),ROW()-ROW($I$4)+1)-ROW($I$4)+1))
When the schedule was full, data was not being copied or was transferred to the wrong sheet.
I deleted most of the entries in order to start again but have found that my entries are not being copied or are returning nil/zeros
I am lost!
Any suggestions?
Thank you