I have a spreadsheet with multiple tabs that I do various formula's with. The rows of data vary between the worksheets. Each worksheet would have the same formula in same column.
To get the formula on all the tabs, I click all the tabs involved and put my formula in the column with the first row of data. If I were to copy the formula down by double clicking the square in the lower right hand corner of the cell, the formula copies down to the last row of data on the "active" tab. My problem is that the number of rows on each sheet is not the same.
Example: Sheet 1 has 50 rows, sheet 2 has 100 rows and sheet 3 has 25 rows. If I were to start with sheet 1, hold control key and then click sheet 2 and sheet 3, then, now what ever I do on sheet 1 will also apply to sheets 2 and 3. If I were to put a formula in column F (on sheet 1), double click the square in the lower right corner of the cell, the formula would then copy down to my last row of data which is line 50. My problem is that sheet 2 needs that formula to go to row 100 and sheet 3 needs the formula to stop at row 25 but is stopping at line 50.
Is there a way to copy down the data on multiple tabs so the formula stops at the last line of data on each tab? I hope I am explaining this clearly enough...
To get the formula on all the tabs, I click all the tabs involved and put my formula in the column with the first row of data. If I were to copy the formula down by double clicking the square in the lower right hand corner of the cell, the formula copies down to the last row of data on the "active" tab. My problem is that the number of rows on each sheet is not the same.
Example: Sheet 1 has 50 rows, sheet 2 has 100 rows and sheet 3 has 25 rows. If I were to start with sheet 1, hold control key and then click sheet 2 and sheet 3, then, now what ever I do on sheet 1 will also apply to sheets 2 and 3. If I were to put a formula in column F (on sheet 1), double click the square in the lower right corner of the cell, the formula would then copy down to my last row of data which is line 50. My problem is that sheet 2 needs that formula to go to row 100 and sheet 3 needs the formula to stop at row 25 but is stopping at line 50.
Is there a way to copy down the data on multiple tabs so the formula stops at the last line of data on each tab? I hope I am explaining this clearly enough...
