I have this excel sheet and I would like it to
1. Once a treatment is written in the treatment column , it is copied into the "treatment dispensed" sheet and the GU Code copied accordingly. If there is no value that it is not copied.
Example -
with medication A I would have dispensed it to code 1 and therefore on medication dispensed sheet i'd see
"Code - 1 " "medication - A "
Could you please help?
tried creating an IFERROR formula but got stuck.
Thanks
A
Bookmarks