troubleshooting Question

Excel Macros? Possibility to do this?

Avatar of lisafamf
lisafamfFlag for United States of America asked on
Microsoft ExcelInstallation
11 Comments1 Solution97 ViewsLast Modified:
Hi!
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros