H
Humming Bird
1. I have five stores. At the end of the day each stores enters stats for
the day in an excel worksheet and saves it.
2. I would like to open up a worksheet and be able to scroll down through
data that was entered on each of the five store locations. Just as the
store would have looked at it... only I could scroll down to the next
stores info.
3. I know how to do cell refrences... but how do you bring an entire sheet
into your local worksheet? Anyway to say that this area a1:z26 equals the
looked up range of cells?
Thanks for any thoughts the group may have.
the day in an excel worksheet and saves it.
2. I would like to open up a worksheet and be able to scroll down through
data that was entered on each of the five store locations. Just as the
store would have looked at it... only I could scroll down to the next
stores info.
3. I know how to do cell refrences... but how do you bring an entire sheet
into your local worksheet? Anyway to say that this area a1:z26 equals the
looked up range of cells?
Thanks for any thoughts the group may have.