Use an indirect formula to connect to the next row in Microsoft Excel.
Use an indirect formula to connect to the next row in Microsoft Excel.
Hi all
In Microsoft Excel I am attempting to apply the following formula down the rows: =IF(OR(INDIRECT("Master!$N$8")=STATUS8, INDIRECT("Master!$N$8")=STATUS9), 0, INDIRECT("Master!$M$8)). This formula is in a sheet named hours, which references values from a sheet called Master. The cells I am searching for are labeled STATUS8 and STATUS9. On the master sheet, when a row reaches the status "delivered", a macro copies the row to another sheet called compete and removes it from the master sheet. To avoid formula breaks after deletion, I use INDIRECT so that removing lines doesn’t disrupt the links. I’m struggling to copy this down efficiently, especially with around 2000 lines, and would appreciate any guidance.
It seems you're uncertain about the details you're explaining. The process would involve choosing the desired row, copying it, pasting it into the target spreadsheet, and then selecting that row again. Adjust the Shift key while dragging to highlight the relevant rows. For more guidance, refer to the detailed instructions provided. Be mindful of using dollar signs to reference specific cells, rows, or columns. This method is referred to as Absolute References.
It seems uncertain about the details you mention. The process would involve choosing the desired row, copying its content, pasting it into the target spreadsheet, and then selecting that row again. Adjusting the reference is done by using absolute references. For more guidance, refer to the links provided. Be mindful of using dollar signs when fixing cells, rows, or columns. Additional explanations can be found online.