1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Transferring data from one worksheet to another based on drop down selection

I'm trying to move data from Columns H, J, K, N, and O in Row 1 from Sheet1 to Sheet2 when "Yes" is selected from the dropdown list in Column P, Row 1 of Sheet1.

I tried a few different formulas I found online but nothing seems to be doing the trick. This is my last laughable attempt:

=FILTER(Sheet1!H1+J1+K1+N1+O1,Sheet1!P:P="Yes")

Any insight on what I'm doing wrong, or if what I'm attempting is even possible? Thank you.

submitted by /u/Adept-Swim-400
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com