Folks I need help ASAP, and I am sure this is the wrong forum to place this in, but I am not sure where it should go. I am trying to work on automating a report where sheet 1, looks at sheet 2 for data to copy over. Specifically, I need Cell X on sheet 1 to look at column B on sheet 2. If it can find a string of words "XXX" then it will copy Cell Y, from a different column on sheet 2 to cell X on sheet 1. If its not present, then I either want a 0 in cell x on sheet 1 or for it to be left blank.
PLEASE HELP ME. I have been banging my head, researching this issue for days to no avail. Thank you for any and all assistance.
Bookmarks