i need a vba
if condition is met then copy cell data to another sheet and save it automatically
if condition is met then take a screen shot and past it to sheet or save it as pic automatically.
plz help how to write vba for this?
thanks in advance