Forum Discussion
Autopopulate from one worksheet to the next available space in worksheet
Hi, You can do this with array functions, have a look at the attached, let me know if this is what you were after.
Thank you,
Hi, You can do this with array functions, have a look at the attached, let me know if this is what you were after.
Thank you,
- Thank you for the information. For the last section you input a formula between three and six. I now want the first section to be between 0 and 1. So I tried to copy the last section formula and paste it unto the first section, but it did not work. Can you assist? Please see attachment
How is this?
Copying and pasting the cell won't work as the last part of the formula is not (And can't be due to the how the array function works) an absolute value so it changes when you copy the cell, in this case it wants to change to A-29, which can't happen, hence ROW(#REF!).
I did the attached by copying the formula (Ie. Double click into the cell and copy the formula) itself in C50 and pasting into C20, then changed the 3 and 6 to 0 and 1 as appropriate, hit CTRL+SHIFT+ENTER to make it an array formula and then drag the cell handle down to C31, then rinse and repeat for D,E,F,G and H.
- Thank you for your assistance.
Yes this is awesome! Thank you.
