Maneesh Massey
Member
Dear All,
I have an Excel table in which I have 16 stages of development of a certain product (say Stage1, Stage2, Stage3 and so on ...) in column A1 to A15 and I have other consecutive columns B1 (Date of Process) C1 (No. of Staff in Shift) and D1 (Status of Product - Complete or In Progress). I have 5 different locations where the product is manufactured.
Down below in the same or different worksheet, I would like to have the name of the stages, date of the process, the no. of staff in the shift and the status of the product - whether complete or in progress appear in the same sequence as the table above it. The key index factor would be the date the user enters into the table above in the date column. So, suppose if in Location 4, someone would put a Date of Process like October 22, 2018, I want Excel to return the entire row of corresponding information retrieved. If the person enters a date in another location (say location 3), the entire corresponding row of information should display in the table below the table above in another new blank row leaving the row above with information already filled in.
Is this possible with VBA code?
I have attached the Excel sheet for this with this question.
Please someone help.
I have an Excel table in which I have 16 stages of development of a certain product (say Stage1, Stage2, Stage3 and so on ...) in column A1 to A15 and I have other consecutive columns B1 (Date of Process) C1 (No. of Staff in Shift) and D1 (Status of Product - Complete or In Progress). I have 5 different locations where the product is manufactured.
Down below in the same or different worksheet, I would like to have the name of the stages, date of the process, the no. of staff in the shift and the status of the product - whether complete or in progress appear in the same sequence as the table above it. The key index factor would be the date the user enters into the table above in the date column. So, suppose if in Location 4, someone would put a Date of Process like October 22, 2018, I want Excel to return the entire row of corresponding information retrieved. If the person enters a date in another location (say location 3), the entire corresponding row of information should display in the table below the table above in another new blank row leaving the row above with information already filled in.
Is this possible with VBA code?
I have attached the Excel sheet for this with this question.
Please someone help.
