I have two worksheets in the same workbook. If it finds the model number "BE20" in column C of Sheet 1, then I'd like it to copy specific cells within that row (ie, j to ac on that row), if it does not find it in that column then all of those cells would be 0 (but I know it won't be 0, I will make sure that the model numbers I'm using in my formula are actually in sheet 1).
I've been trying to use the IF function for this but I've had no success. I know there are two instances of BE20 in sheet 1 but it's still not finding them.
And I don't even know if the cells within the row that it finds can be copied automatically from one sheet to the other.
And fyi, I've kept the same formatting for all of the copied cells on both sheets.
I am expecting that sheet 1 will have 3500+ lines by the time everything is said and done and because of that it would be really nice to have a formula on sheet 2 to just have totals for all of the cells that have data for the specific model numbers.
Right now I've just done a straight copy of the cells from sheet 1 to sheet 2 and put it in a table so that it can be sorted by model number and then totalled with a formula periodically. If I do it this way, then each sheet will have 3500+ lines and I'm worried about it eventually getting corrupted because it's going to be such a large, unwieldy document. I know - backup, backup, backup lol.
I have an old document that had a formula in sheet2 that clearly doesn't work and I don't think it ever did but this is the old sheet2 model totalling formula: