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
Last edited by JoseK70; 01-03-2012 at 11:39 AM.
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.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
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.Originally Posted by arlu1201
Do you mean you want to keep C22 to C27 count live, while resetting the other cells?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks