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.)
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.) Read More
