DIVINEDAR0956
IS-IT--Management
I was told that my english is not very well so please excuse me. I have in excel approximately 100 sheets of a design form that the employees use to input data. This form is in increments of 12 months and leads up to 5 years. In other words this same form is on one sheet 5 times for up to 60 months. For instance:
Cell E8 on the first sheet consist of the Proposal Number which is automatically filled in on all sheets because it is a common value. There are also other common values in Row E which are automatically filled. When this information is filled in it goes to a sheet at the end of the document used to import into Access.
My dilemma is that when R23:R37 has a value greater than 0 the input the corresponding code from F22:Q22 such as AW, EN, CE, etc. What I am seeking is a formula that says if FOR INSTANCE: IF(R23>0,"AW",""
OR IF(R24>0,"CE",""OR IF(R25>0,"EN","" etc. I need for this to loop through each row on the input sheet that is being imported in access.
Also on the input sheet are Months 1 thorugh 60 that corresponds with the AW, CE, EN, etc. I have the following labels on the input sheet, PROJECT NUMBER, WBS ITEM NUMBER, LABOR CODE (which is AW, CE, EN, etc.) and MONTHS 1 THROUGH 60. One other way is that if Months 1 through 60 is greater than 0 then insert the corresponding Project Number, WBS Item Number and Labor Code.
I pray that someone understands where I'm coming from. Thank you and God bless whomever answers me.
Cell E8 on the first sheet consist of the Proposal Number which is automatically filled in on all sheets because it is a common value. There are also other common values in Row E which are automatically filled. When this information is filled in it goes to a sheet at the end of the document used to import into Access.
My dilemma is that when R23:R37 has a value greater than 0 the input the corresponding code from F22:Q22 such as AW, EN, CE, etc. What I am seeking is a formula that says if FOR INSTANCE: IF(R23>0,"AW",""
OR IF(R24>0,"CE",""OR IF(R25>0,"EN","" etc. I need for this to loop through each row on the input sheet that is being imported in access.Also on the input sheet are Months 1 thorugh 60 that corresponds with the AW, CE, EN, etc. I have the following labels on the input sheet, PROJECT NUMBER, WBS ITEM NUMBER, LABOR CODE (which is AW, CE, EN, etc.) and MONTHS 1 THROUGH 60. One other way is that if Months 1 through 60 is greater than 0 then insert the corresponding Project Number, WBS Item Number and Labor Code.
I pray that someone understands where I'm coming from. Thank you and God bless whomever answers me.
