M
Mycotopian
Hi guys. This is my first post here but so far I have gotten alot o
questions asked just by searching. Here is my prediciment.
I have team totals that I refresh everyday and what I would like to d
is only update a hidden data sheet and have excel pull all of th
relivant data onto each teams sheet for a more detailed view. Th
problem I am having is that the number of entries will vary from day t
day so I cannot set it to be static to individual cells. It would b
nice if I could pull an entire line of data based on the content of on
cell but I dont know of that is possible. This should give you an ide
of what I am working with. Let me know if I need to clarify
Date Team TeamMember $ Product
1 1 100
a
2 1 130
questions asked just by searching. Here is my prediciment.
I have team totals that I refresh everyday and what I would like to d
is only update a hidden data sheet and have excel pull all of th
relivant data onto each teams sheet for a more detailed view. Th
problem I am having is that the number of entries will vary from day t
day so I cannot set it to be static to individual cells. It would b
nice if I could pull an entire line of data based on the content of on
cell but I dont know of that is possible. This should give you an ide
of what I am working with. Let me know if I need to clarify
Date Team TeamMember $ Product
1 1 100
a
2 1 130