Hello I am trying to copy cells A3-34(sheet3) except where the value of the cell is equal to the value
of any cells in P2-100(sheet1) then paste those values into H2-33(sheet3)
Then If possible I would also like to delete any cell outside of a range specified by a value in H1(sheet3)
So if the value in H1(sheet3) is 8, then any value outside of H2-9(sheet3) but within H2-33(sheet3), would be deleted.
Is this possible?
of any cells in P2-100(sheet1) then paste those values into H2-33(sheet3)
Then If possible I would also like to delete any cell outside of a range specified by a value in H1(sheet3)
So if the value in H1(sheet3) is 8, then any value outside of H2-9(sheet3) but within H2-33(sheet3), would be deleted.
Is this possible?