Hello all,
I have a spreadsheet which highlights the efficiency of a production line. I have 1 sheet for the week and the fields would be day, shift, product code, line, std units per min, act upm. I wabt to set up this as a weekly sheet and then have a sheet which consolidates all this data as 1 for a monthly consolidated sheet. Any help on how I would do this would be greatly appreciated. I have looked at running a pivot table over multiple sheets but its above my knowledge level.
Thank you
Bookmarks