Hi All,

Hoping someone can help me out.

I am working on a spread sheet which tracks warehouse picking the formatting for the input was not designed by me but has been done to be user friendly. It does not, however, help at all for me trying to do analysis from this sheet.

The sheet itself works day by day scrolling horizontally making 365 entries. What I want to be able to do is find the correct function so that I can pull data without having to laboriously use = and defining each cell as the autofill is not picking up the pattern for the number of columns changed between the days.


can anyone help please

tried to upload images but request timed out.