Joke Collection Website - Blessing messages - Jj landlord 2 yuan phone bill shows that the mobile phone number you entered cannot be recharged. Please contact customer service. What happened?

Jj landlord 2 yuan phone bill shows that the mobile phone number you entered cannot be recharged. Please contact customer service. What happened?

Can be achieved. Scheme 1: To set the formula method, you need to set the information table in advance and set the formula in the corresponding area, that is, the column corresponding to the next line of your input content. You need to set formulas in as many fields as possible. The formula is solved by hlookup function or index+match function. The advantage of this method is that Excel has built-in functions, which are relatively easy to write and can be updated in real time, even if the information table is updated. The disadvantage is that the formula needs to be preset and filled in the corresponding area first. If there is no preset position, it will not be calculated after filling in. You need to manually fill in or copy the formula once. The second method: VBA method, using VBA to write a macro that responds to the change event. Correspond directly after input, and automatically fill the data into the corresponding cells according to the correspondence you edited in advance. The advantage of this method is that any column can be automatically filled in, and there is no default value. The disadvantage is that it is only updated when the input data is modified, but the information table update is not easy to handle. Of course, you can do it if you want, but the code is more complicated to write and slower to process because you have to check all the input. In addition, to write code, the requirements for operation are high. In terms of logical processing, VBA can solve almost all logical problems you can think of. If you need help, you can write privately. It is better to deal with the original table.