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'.
I want the 3 columns in the 'Front_Page that contain no data at present because I do not know how populate them with dates that will change as part progresses through the columns to the right through the cell squares.
Important is that the 'Front_Page cells are designed around 1's and 0's. 1=required and 0=bot required.
These 1's and 0's are collected from the different worksheets and dropped into the correct cells on the 'Front_Page'
When 1 is found in a worksheet for example NOV1 Column I then column N8 requires a date to entered by someone when they send the part to NOV1.
I need the date in Cell NOV1 K8 to be entered automatically into 'Front_Page' G8. This is the immediate planned start date. This is for reference and advises someone that this should of happened on or dbefore that date.
I also need to do the same Cell NOV1 L8 and dropped into the 'Front_Page' H8. This is the End Date of the operation. Again this advise me that this part should of been back by this date.
I also want Excel to work though Row 8 in the 'Front_Page' and find the next 1 ignoring the 0's.
When the next 1 is found to take the K8 value from the Worksheet in the Heading of that column and drop that Date into I8 in the Front_Page'
In 'Front_Page' Row 8 next number 1 is found Cell P8 info coming from 'CB' N8,
Ignore the 0's in cells R8 & T8 in the 'Front_Page'
When the cell colour of the active column changes from WHITE or YELLOW to GREEN this means that NOV1 is finished and the three cells G8, H8 & I8 must change to the next dates found by searching right in the Row8 and finding the next number 1.
Attached is the shortened version of the Workbook
My full Work has 3007 rows and I need to apply to 3000 of them on the 'Front_Page'
Hope someone can help.
thanks in advanced
Michael
Attachment | Size |
---|---|
SHORT VERSION.xlsx | 809.73 KB |
- Michael O'Flanagan's blog
- Login or register to post comments
- 11404 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago