Attached is a document that a few people here have helped me with! I need a bit more help.
I would like to auto populate columns B and C of worksheet16-Q3 by finding out this information:
When I type a name in column A of 16-Q3 I would like it to look at ALL worksheets for that name and if there is a 4 in that row in column J, I would like it to fill out Columns B and C of 16-Q3, with what is in in columns G and H of that same row. B=G and C=H.
I have no idea if this can be accomplished, lol, but I thank you all in advance!
Lisa :) mastercalltoEE.xlsm