Forum Discussion

kbbaker575's avatar
kbbaker575
Copper Contributor
Jan 04, 2019
Solved

Autopopulate from one worksheet to the next available space in worksheet

So I have two worksheets, one labeled daily and the other Sig events. The sig events tab has multiple types from a-I. it also has a timeframe column with different numbers. If the timeframe is <=1, i...
Formulas and Functions
  • JWR1138's avatar
    JWR1138
    Jan 04, 2019

    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, 

JWR1138's avatar
JWR1138
Iron Contributor
Jan 04, 2019

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, 

kbbaker575's avatar
kbbaker575
Copper Contributor
Jan 10, 2019
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
  • JWR1138's avatar
    JWR1138
    Iron Contributor
    Jan 10, 2019

    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. 

     

     

    • kbbaker575's avatar
      kbbaker575
      Copper Contributor
      Jan 11, 2019
      Thank you for your assistance.