Spreadsheet: 232130d1367337643-entering-data-for-an-inventory-list-which-is-dynamic-causes-issues-when-the-list-changes-historical-data-solution
Sheet: Master List - Historical Data

 | Product ID | 01-Jan-12 | 02-Jan-12 | 03-Jan-12 | 04-Jan-12 | 05-Jan-12 | 06-Jan-12 | 07-Jan-12 | 08-Jan-12 | 09-Jan-12 | 10-Jan-12 | 11-Jan-12 | 12-Jan-12 | 13-Jan-12 | 14-Jan-12 | 15-Jan-12 | 16-Jan-12 | 17-Jan-12 | 18-Jan-12 | 19-Jan-12 | 20-Jan-12 | 21-Jan-12 | 22-Jan-12 | 23-Jan-12 | 24-Jan-12 | 25-Jan-12 | 26-Jan-12 | 27-Jan-12 | 28-Jan-12 | 29-Jan-12 | 30-Jan-12 | 31-Jan-12 | 01-Feb-12 | 02-Feb-12 | 03-Feb-12 | 04-Feb-12 | 05-Feb-12 | 06-Feb-12 | 07-Feb-12 | 08-Feb-12 | 09-Feb-12 | 10-Feb-12 | 11-Feb-12 | 12-Feb-12 | 13-Feb-12 | 14-Feb-12 | 15-Feb-12 | 16-Feb-12 | 17-Feb-12 | 18-Feb-12 | 19-Feb-12 | 20-Feb-12 | 21-Feb-12 | 22-Feb-12 | 23-Feb-12 | 24-Feb-12 | 25-Feb-12 | 26-Feb-12 | 27-Feb-12 | 28-Feb-12 | 29-Feb-12 | 01-Mar-12 | 02-Mar-12 | 03-Mar-12 | 04-Mar-12 | 05-Mar-12 | 06-Mar-12 | 07-Mar-12 | 08-Mar-12 | 09-Mar-12 | 10-Mar-12 | 11-Mar-12 | 12-Mar-12 | 13-Mar-12 | 14-Mar-12 | 15-Mar-12 | 16-Mar-12 | 17-Mar-12 | 18-Mar-12 | 19-Mar-12 | 20-Mar-12 | 21-Mar-12 | 22-Mar-12 | 23-Mar-12 | 24-Mar-12 | 25-Mar-12 | 26-Mar-12 | 27-Mar-12 | 28-Mar-12 | 29-Mar-12 | 30-Mar-12 | 31-Mar-12 | 01-Apr-12 | 02-Apr-12 | 03-Apr-12 | 04-Apr-12 | 05-Apr-12 | 06-Apr-12 | 07-Apr-12 | 08-Apr-12 | 09-Apr-12 | 10-Apr-12 | 11-Apr-12 | 12-Apr-12 | 13-Apr-12 | 14-Apr-12 | 15-Apr-12 | 16-Apr-12 | 17-Apr-12 | 18-Apr-12 | 19-Apr-12 | 20-Apr-12 | 21-Apr-12 | 22-Apr-12 | 23-Apr-12 | 24-Apr-12 | 25-Apr-12 | 26-Apr-12 | 27-Apr-12 | 28-Apr-12 | 29-Apr-12 | 30-Apr-12 | 01-May-12 | 02-May-12 | 03-May-12 | 04-May-12 | 05-May-12 | 06-May-12 | 07-May-12 | 08-May-12 | 09-May-12 | 10-May-12 | 11-May-12 | 12-May-12 | 13-May-12 | 14-May-12 | 15-May-12 | 16-May-12 | 17-May-12 | 18-May-12 | 19-May-12 | 20-May-12 | 21-May-12 | 22-May-12 | 23-May-12 | 24-May-12 | 25-May-12 | 26-May-12 | 27-May-12 | 28-May-12 | 29-May-12 | 30-May-12 | 31-May-12 | 01-Jun-12 | 02-Jun-12 | 03-Jun-12 | 04-Jun-12 | 05-Jun-12 | 06-Jun-12 | 07-Jun-12 | 08-Jun-12 | 09-Jun-12 | 10-Jun-12 | 11-Jun-12 | 12-Jun-12 | 13-Jun-12 | 14-Jun-12 | 15-Jun-12 | 16-Jun-12 | 17-Jun-12 | 18-Jun-12 | 19-Jun-12 | 20-Jun-12 | 21-Jun-12 | 22-Jun-12 | 23-Jun-12 | 24-Jun-12 | 25-Jun-12 | 26-Jun-12 | 27-Jun-12 | 28-Jun-12 | 29-Jun-12 | 30-Jun-12 | 01-Jul-12 | 02-Jul-12 | 03-Jul-12 | 04-Jul-12 | 05-Jul-12 | 06-Jul-12 | 07-Jul-12 | 08-Jul-12 | 09-Jul-12 | 10-Jul-12 | 11-Jul-12 | 12-Jul-12 | 13-Jul-12 | 14-Jul-12 | 15-Jul-12 | 16-Jul-12 | 17-Jul-12 | 18-Jul-12 | 19-Jul-12 | 20-Jul-12 | 21-Jul-12 | 22-Jul-12 | 23-Jul-12 | 24-Jul-12 | 25-Jul-12 | 26-Jul-12 | 27-Jul-12 | 28-Jul-12 | 29-Jul-12 | 30-Jul-12 | 31-Jul-12 | 01-Aug-12 | 02-Aug-12 | 03-Aug-12 | 04-Aug-12 | 05-Aug-12 | 06-Aug-12 | 07-Aug-12 | 08-Aug-12 | 09-Aug-12 | 10-Aug-12 | 11-Aug-12 | 12-Aug-12 | 13-Aug-12 | 14-Aug-12 | 15-Aug-12 | 16-Aug-12 | 17-Aug-12 | 18-Aug-12 | 19-Aug-12 | 20-Aug-12 | 21-Aug-12 | 22-Aug-12 | 23-Aug-12 | 24-Aug-12 | 25-Aug-12 | 26-Aug-12 | 27-Aug-12 | 28-Aug-12 | 29-Aug-12 | 30-Aug-12 | 31-Aug-12 | 01-Sep-12 | 02-Sep-12 | 03-Sep-12 | 04-Sep-12 | 05-Sep-12 | 06-Sep-12 | 07-Sep-12 | 08-Sep-12 | 09-Sep-12 | 10-Sep-12 | 11-Sep-12 | 12-Sep-12 | 13-Sep-12 | 14-Sep-12 | 15-Sep-12 | 16-Sep-12 | 17-Sep-12 | 18-Sep-12 | 19-Sep-12 | 20-Sep-12 | 21-Sep-12 | 22-Sep-12 | 23-Sep-12 | 24-Sep-12 | 25-Sep-12 | 26-Sep-12 | 27-Sep-12 | 28-Sep-12 | 29-Sep-12 | 30-Sep-12 | 01-Oct-12 | 02-Oct-12 | 03-Oct-12 | 04-Oct-12 | 05-Oct-12 | 06-Oct-12 | 07-Oct-12 | 08-Oct-12 | 09-Oct-12 | 10-Oct-12 | 11-Oct-12 | 12-Oct-12 | 13-Oct-12 | 14-Oct-12 | 15-Oct-12 | 16-Oct-12 | 17-Oct-12 | 18-Oct-12 | 19-Oct-12 | 20-Oct-12 | 21-Oct-12 | 22-Oct-12 | 23-Oct-12 | 24-Oct-12 | 25-Oct-12 | 26-Oct-12 | 27-Oct-12 | 28-Oct-12 | 29-Oct-12 | 30-Oct-12 | 31-Oct-12 | 01-Nov-12 | 02-Nov-12 | 03-Nov-12 | 04-Nov-12 | 05-Nov-12 | 06-Nov-12 | 07-Nov-12 | 08-Nov-12 | 09-Nov-12 | 10-Nov-12 | 11-Nov-12 | 12-Nov-12 | 13-Nov-12 | 14-Nov-12 | 15-Nov-12 | 16-Nov-12 | 17-Nov-12 | 18-Nov-12 | 19-Nov-12 | 20-Nov-12 | 21-Nov-12 | 22-Nov-12 | 23-Nov-12 | 24-Nov-12 | 25-Nov-12 | 26-Nov-12 | 27-Nov-12 | 28-Nov-12 | 29-Nov-12 | 30-Nov-12 | 01-Dec-12 | 02-Dec-12 | 03-Dec-12 | 04-Dec-12 | 05-Dec-12 | 06-Dec-12 | 07-Dec-12 | 08-Dec-12 | 09-Dec-12 | 10-Dec-12 | 11-Dec-12 | 12-Dec-12 | 13-Dec-12 | 14-Dec-12 | 15-Dec-12 | 16-Dec-12 | 17-Dec-12 | 18-Dec-12 | 19-Dec-12 | 20-Dec-12 | 21-Dec-12 | 22-Dec-12 | 23-Dec-12 | 24-Dec-12 | 25-Dec-12 | 26-Dec-12 | 27-Dec-12 | 28-Dec-12 | 29-Dec-12 | 30-Dec-12 | 31-Dec-12
 | A-A
X | A-A-1
 | A-B
 | A-C
 | A-D
X | A-D-1
 | A-E
 | A-F
 | A-G
 | A-H
 | A-I
 | A-J
 | A-K
 | A-L
 | A-M
 | A-N
 | A-O
 | A-P
 | A-Q
 | A-R
 | A-S
 | A-T
 | A-U
 | A-V
 | A-W
 | A-X
 | A-Y
 | A-Z
 | B-A
 | B-B
 | B-C
 | B-D
 | B-E
 | B-F
 | B-G
 | B-H
 | B-I
 | B-J
 | B-K
 | B-L
 | B-M
 | B-N
 | B-O
 | B-P
 | B-Q
 | B-R
 | B-S
 | B-T
 | B-U
 | B-V
 | B-W
 | B-X
 | B-Y
 | B-Z
 | C-A
 | C-B
 | C-C
 | C-D
 | C-E
 | C-F
 | C-G
 | C-H
 | C-I
 | C-J
 | C-K
 | C-L
 | C-M
 | C-N
 | C-O
 | C-P
 | C-Q
 | C-R
 | C-S
 | C-T
 | C-U
 | C-V
 | C-W
 | C-X
 | C-Y
 | C-Z
 | D-A
 | D-B
 | D-C
 | D-D
 | D-E
 | D-F
 | D-G
 | D-H
 | D-I
 | D-J
 | D-K
 | D-L
 | D-M
 | D-N
 | D-O
 | D-P
 | D-Q
 | D-R
 | D-S
 | D-T
 | D-U
 | D-V
 | D-W
 | D-X
 | D-Y
 | D-Z
 | E-A
 | E-B
 | E-C
 | E-D
 | E-E
 | E-F
 | E-G
 | E-H
 | E-I
 | E-J
 | E-K
 | E-L
 | E-M
 | E-N
 | E-O
 | E-P
 | E-Q
 | E-R
 | E-S
 | E-T
 | E-U
 | E-V
 | E-W
 | E-X
 | E-Y
 | E-Z
 | F-A
 | F-B
 | F-C
 | F-D
 | F-E
 | F-F
 | F-G
 | F-H
 | F-I
 | F-J
 | F-K
 | F-L
 | F-M
 | F-N
 | F-O
 | F-P
 | F-Q
 | F-R
 | F-S
 | F-T
 | F-U
 | F-V
 | F-W
 | F-X
 | F-Y
 | F-Z