=query(CASES,"select C,E,F,G,H,I,J,K,L,P,Q,R where Q matches 'Admission|Pending|Transferred' AND R isnull ORDER BY R ASC ",0)
我使用这个公式将数据过滤到工作表中。然后,我想根据一个标准更改列N的值。这是(如果单元格M2=“是”,则列N的值</em
我的朋友需要帮助处理这段代码 Dim R As String Dim G As StringSet givenrng = Sheets("Sheet1").Cells(2, 3)
'If Worksheets("Project Details").Range("L") = RAnd Worksheets("Project Detials")