Forum Discussion

Copper Contributor

Jun 02, 2023

Solved

insert DATA from one sheet to another..

i have a worksheet full of data, i have a list of names in column 1 .. i then have rows after each of them of Dates of when assessments are due.. (in columns 3 month, 6 month and so on) .... ...

Test.xlsx16 KB

excel

Formulas and Functions

Macros and VBA

OliverScheurich
Jun 03, 2023
jayde-deanne
=IFERROR(INDEX(Sheet1!$B$3:$B$500,SMALL(IF(MMULT(N(Sheet1!$G$3:$L$500=Sheet2!B$3),ROW($1:$6)^0)=1,ROW($1:$498)),ROW(1:1))),"")
You are welcome. With this formula you can enter employees in range B3:B500 and their corresponding dates in range G3:L500.
Test.xlsx31 KB

jayde-deanne

Copper Contributor

Jun 02, 2023

Yes that now works on this sheet, but again i have tried now applying it to my full sheet, and it is not working again...

I have now edited my test sheet so that no names appear but this is exactly how it looks, but i would like it to be able to pick up more rows than i actually have for any new employees that start .. then i dont have to change any of the formula? .... I am so so sorry, i thank you for all your help so far! its exactly what i want, but i dont know why i cant get it to work when i edit it to the main sheet....

Test.xlsx30 KB

OliverScheurich

Gold Contributor

Jun 03, 2023

jayde-deanne

=IFERROR(INDEX(Sheet1!$B$3:$B$500,SMALL(IF(MMULT(N(Sheet1!$G$3:$L$500=Sheet2!B$3),ROW($1:$6)^0)=1,ROW($1:$498)),ROW(1:1))),"")

You are welcome. With this formula you can enter employees in range B3:B500 and their corresponding dates in range G3:L500.

Test.xlsx31 KB

jayde-deanne
Copper Contributor
Jun 03, 2023
My friend!!!!.. You are an absolute GENIUS!!! --- Thank you so so much!!!!!!!