Michael O'Flanagan's blog

Collect the correct date from 1 of 32 worksheets into 1 cell and change as it progresses through the 32 worksheets when part mov

Hi,

Can anybody possibly help with my problem.
I have a Workbook containing approx 32 worksheets. This is the short version due to max up load and only contains the first 11 sheets.

I apologise if I do not explain this well as I am not an expert in Excel.

The main Worksheet is 'Front_Page' which does all the reporting of the other work sheets.
The Header Titles in the Red cells in Row 6 match the titles of the worksheets starting with 'MATL'.

Syndicate content