Looking for auto-population across sheets.
Hi, here is my doc:
I volunteer for a rescue and I am looking for info to auto populate on a sheet. Basically, if Column Q on "Master Sheet" says Christine, I would like Column E to autopopulate on "Active Fosters" Column B if that makes sense. To compound things, sometimes we have more than one foster so I am not sure if there is a way for more than one foster to show on a line, no biggie if it is just the first one to be honest.
Is this possible?