hooper12345
New Member
- Joined
- May 12, 2015
- Messages
- 36
Hello all,
I have a very large workbook that is broken down into results and data per floor. I would like to reference the data tab to pull into the results tab. There are 8 graphs that I need to populate from the data. It is on a weekly basis and the data cell I need is very fifth. Example: Number of visits graph; Goal=20; data from actual # F4, F9, F14 then the next graph would pull data from column K. Is there a way to auto populate these numbers without doing it by hand?
I have a very large workbook that is broken down into results and data per floor. I would like to reference the data tab to pull into the results tab. There are 8 graphs that I need to populate from the data. It is on a weekly basis and the data cell I need is very fifth. Example: Number of visits graph; Goal=20; data from actual # F4, F9, F14 then the next graph would pull data from column K. Is there a way to auto populate these numbers without doing it by hand?