Hello all,
I am attempting to build a spreadsheet that I manually insert information into a tab from a document that I receive from a customer monthly. The format of the document received is Excel and can include in excess of 1,000 line items. Example Tabs inserted are a very small representation.
The contents includes a unit Identification (ID) number in Column A with corresponding hours worked by a specific maintenance team in Column B and C. Additionally, the two teams total hours worked would also be calculated in A4. The total hours of A4 is an easy auto sum that I can accomplish without assistance.
The ID numbers and quantities in column A fluxuate from month to month. They do not always repeat from month to month so utilizing a single list in column A is not feasible. An ID number that does not receive maintenance from either team will not be included in the data I receive and therefore is not calculated as a "zero". I.E. One ID# could have 50 hours for Team A and 35 hours for Team B during Jan, zero hours for both teams for Feb. March then may incur 200 and 700 hours respectively.
Once I Copy/Paste the data received into the month tab, I.E. “Jan 2022” I create a new Tab for Feb, Mar, etc...
The overall BIG problem : I am in need of having a TOTAL TAB in the worksheet that looks at each month within the spreadsheet continuously and retrieves the ID# in Column A with the corresponding and calculated total hours worked by a specific maintenance team in Column B, and C. With this I can then auto sum Column D.
Any assistance and advice from the guru's would be greatly appreciated.
JT
I am attempting to build a spreadsheet that I manually insert information into a tab from a document that I receive from a customer monthly. The format of the document received is Excel and can include in excess of 1,000 line items. Example Tabs inserted are a very small representation.
The contents includes a unit Identification (ID) number in Column A with corresponding hours worked by a specific maintenance team in Column B and C. Additionally, the two teams total hours worked would also be calculated in A4. The total hours of A4 is an easy auto sum that I can accomplish without assistance.
The ID numbers and quantities in column A fluxuate from month to month. They do not always repeat from month to month so utilizing a single list in column A is not feasible. An ID number that does not receive maintenance from either team will not be included in the data I receive and therefore is not calculated as a "zero". I.E. One ID# could have 50 hours for Team A and 35 hours for Team B during Jan, zero hours for both teams for Feb. March then may incur 200 and 700 hours respectively.
Once I Copy/Paste the data received into the month tab, I.E. “Jan 2022” I create a new Tab for Feb, Mar, etc...
The overall BIG problem : I am in need of having a TOTAL TAB in the worksheet that looks at each month within the spreadsheet continuously and retrieves the ID# in Column A with the corresponding and calculated total hours worked by a specific maintenance team in Column B, and C. With this I can then auto sum Column D.
Any assistance and advice from the guru's would be greatly appreciated.
JT
