Forum Discussion
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.)
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.