conditional copy & paste

  • Thread starter Thread starter sch
  • Start date Start date
S

sch

I want to create a formula that will allow me to COPY cell g83 and PASTE
it to cell d57 IF cell h83 has an X in it.

I guess I'm calling this "conditional copying and pasting". I have
basic/limited experience with excel - sorry if this is a stupid
question.

Thanx
 
if ucase(range("h83"))="X" then range("d57")=range("g83")
or
if ucase(range("h83"))="X" then range("g83").copy range("d57")
 
Hi
try the following formula for D57
=IF(H83="X",G83,"")

some coments:
- if H83 ha no X in it, d57 will be blank
- the above formula is case sensitive. If you will also accept 'x' then
tray the following
=IF(OR(H83="X",H83="x"),G83,"")

HTH
Frank
 
Back
Top