Hello all,
I have the formula =COUNTA(Sheet3!A:A) in a cell to count the amount of rows in column A starting on worksheet 3. I need to be able to use the drag to fill option to populate the remaining cells with data from worksheet 4 and so on. Is there a way to modify this to do so? I've tried messing with nesting COUNTA and INDIRECT but I can't get anything to go.
After using the drag to fill feature down the column, the formulas should read:
Thanks for taking a look!Please Login or Register to view this content.
Bookmarks