Re: To Return Information from cells Across Multiple Rows Based On Value In Cell X
All he is trying to do is distribute the values pulled in from one function across multiple cells, based on the "project manager" field. Normally the output would be spit into a single cell.
Did you ever figure this out? I am trying to accomplish the same thing.
Here is some simple code I am using now:
Public Function FindSeries(TRange As Range, MatchWith As String) For Each cell In TRange If cell.Value = MatchWith Then x = x & cell.Offset(0, -4).Value & ", " End If Next cell If x > 0 Then FindSeries = Left(x, (Len(x) - 2)) End If End Function
It will return your result, but each new value will be added to the same cell with a comma separator.