yudeakurnia
New Member
- Joined
- Jul 9, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Hello, I want to input a lot of data from a production batch into Microsoft Excel with version 2019. I want to search for an effective way to do it and to minimize any mistake from inputting at the wrong column, and to make the process a lot faster, because there's a lot of handwritten notes of the production batch for every single day.
(example)
The Production batch example is stated below in the mini sheet, there are a lot of products and I need to write the composition of the product, and sum it at the end to see how much is used and to be used as a recap, as you can see that the example composition, not every product have the same composition, therefore, it will take a long long time to input it into the table without any formula or function. I think its like if I put P60:12 or AP:23 or something else it will automatically inserted to the respective column, can I do that kind of input in Excel?
any answer will be appreciated
Thanks
------
(example)
The Production batch example is stated below in the mini sheet, there are a lot of products and I need to write the composition of the product, and sum it at the end to see how much is used and to be used as a recap, as you can see that the example composition, not every product have the same composition, therefore, it will take a long long time to input it into the table without any formula or function. I think its like if I put P60:12 or AP:23 or something else it will automatically inserted to the respective column, can I do that kind of input in Excel?
any answer will be appreciated
Thanks
------
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Date | Product | Composition | ||||||||
2 | P60 | HVI650 | AP | DPP | B57 | BB | B2 | ||||
3 | 01-Jun-21 | ExampleProduct1 | 24 | 23 | 23 | 1,2 | 34 | ||||
4 | ExampleProduct2 | 12 | 12 | 23 | 234 | 121 | 12 | ||||
5 | ExampleProduct3 | 12 | 32 | 32 | 67 | ||||||
6 | ExampleProduct4 | 54 | 23 | 12 | |||||||
7 | ExampleProduct5 | 12 | 23 | ||||||||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
C3:I7 | Cell | contains a blank value | text | NO |
C7 | Cell | does not contain a blank value | text | NO |
H7 | Cell | does not contain a blank value | text | NO |
G7 | Cell | does not contain a blank value | text | NO |
F7 | Cell | does not contain a blank value | text | NO |
E7 | Cell | does not contain a blank value | text | NO |
D7 | Cell | does not contain a blank value | text | NO |
C3:I6,J4 | Cell | does not contain a blank value | text | NO |