Problem keeping the count when reseting contents in cells

**JoseK70** · 01-03-2012, 12:35 PM

Hi,

I need help with keeping a count going but the problem is I want to reset the data in my cells. I have two worksheets one called "count" and one called "SData". I am bringing in the "SData" data and would like count to populate for each "person" in the "SData". I have attached the document I am working on and currently the "count" worksheet is only collecting data for Person X. I need the numbers in "count" to reset yet keep the count going depending on what level the person is. Any help would be greatly appreciated.
RoughDraft.xlsx

**arlu1201** · 01-03-2012, 02:52 PM

Its good that you have attached a spreadsheet. It will be nice if you can give an example using the file, probably give cell references so we can help you better.

**JoseK70** · 01-03-2012, 03:13 PM

Originally Posted by arlu1201

Its good that you have attached a spreadsheet. It will be nice if you can give an example using the file, probably give cell references so we can help you better.

Basically I pull data into "SASData" tab. This data is about certain people. In this case it is person X, Y, and Z. From here my "Count" tab pulls in data for person X from the "SASData" tab. This data comes from row 2 of the "SASData" tab and gets put into columns G and H. In this case I am only using four factors. From here the rest of the document figures out what level that person is and counts it in column C rows 23 to 27. My problem is I need to keep that count going and put person Y and Z through to find their levels while keeping the count. I need to run this for 30 people and its a monthly thing so I would like to make it easy to use. Hope that helps. Thanks.