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.
- Previous article:Outlook cannot receive SMS after second authentication.
- Next article:Where is the Li Xinhua community?
- Related articles
- The content of the short message is addressed to 17-year-old self.
- Can you show me the nucleic acid certificate?
- Customer's greetings to heatstroke prevention and cooling in summer
- Bank marketing activity planning plan
- Why is there no message about idle fish on Apple 5s?
- Brief introduction of hospital New Year greetings 202 1
- How does Alipay delete receipts?
- How to cancel the mobile phone number?
- Does this article mean paying back the car loan?
- The daughter found the chat record between her mother and another man. ...