Forum Discussion

MSTS0022's avatar
MSTS0022
Copper Contributor
Jun 24, 2024

Copy data from one sheet to another sheet

Hello everyone, 

 

Previously my formula was working - 

=CHOOSECOLS(FILTER('HL Final Progress Sheet'!$A$2:$O$998, ('HL Final Progress Sheet'!$I$2:$I$998="Ready To Ship")+('HL Final Progress Sheet'!$I$2:$I$998="Ready for P/U"), ""), 10, 9, 2, 11, 12, 13, 14, 15)

 

 

And now there is a requirement to add another column from HL Final Progress Sheet to Driver Work Board, so I change in the above formula - 

 

=CHOOSECOLS(FILTER('HL Final Progress Sheet'!$A$2:$O$998, ('HL Final Progress Sheet'!$I$2:$I$998="Ready To Ship")+('HL Final Progress Sheet'!$I$2:$I$998="Ready for P/U"), ""), 10, 9, 1, 2, 11, 12, 13, 14, 15)

 

How to make it work(my sheet messed up after adding this new change.)

 

 

  • MSTS0022 

    There are a lot of SPILL errors in the first column and first row of your screenshot. The formula should only be in the top left cell; the cells below it and to the right of it should be empty.

Resources