I’m stuck on how to do the following implementation. Could you please tell me how to solve it?
Thank you very much.
In one of the sheets, search by row name and select
If the row name exists, return true. If the row name exists, return true, otherwise, return false.
The formula is contained in the corresponding cell. If some of the calculation items do not exist, they will be assumed to be zero and then calculated.
For example, in Sheet1 of the Master file, one cell contains [E Sales 1 - D Sales 1+ E Sales 2 - D Sales 2].
Sometimes Sales 2 does not exist, and in this case, we need to change the calculation in this cell to 【E Sales 1 - D Sales 1+ 0-0】.
How can I implement this?
※Sales 1 and Sales 2 exist in different Excel files. There are 3 sheets in that file.