tracking

I want to be able to measure the progression of a cell that is in a dropdown in Excel. Once the cell "closes" it is important but it is more important to see what the cell was before it was coded as closed. Is there a way to see what the last item in that cell was? maybe put it in another cell?

Hi Everybody! So at work we have a spreadsheet that lets us keep track of certain types training. The trainings are supposed to be renewed every year. Is there a way for excel to keep track of that one year, then change the cell color to "red" or "orange" once that year is up? The training...

Hi Hope it's OK to ask an open question, but I have problem deciding the best way to "graph" my Trends. I have Students entering the company, on different student schemes (12 in total), with Years of entry over the past 15 years. I want to be able to compare trends, which looks at pay...

Hi This is a bit of a strange and complicated question, hope i get it across right! I'm creating a tracking sheet. I want to use one cell, and update it daily with a new value, eg day 1 = 2, day 2 = 5, day 3 = 12 (this will not be done in a new cell, but rather replace the old unit with the...

I am trying to develop a way of tracking projects for my team. Ideally, this would be a shared workbook, that would allow team members to enter/update projects and also allow for management views. I was thinking I could use a form (?) for the team members and then make this form feed a...

Hello, Turning prompts/alerts off and on in excel is easy with: Application.DisplayAlerts = False ' Your code Application.DisplayAlerts = True However, I am working in a shared workbook. When I want to unshare the workbook, i dont want the prompt "am i sure" bit etc. Adding the bit above, it...

If you have a spreadsheet in which you place an "X" in cells B1:B10 (or rows B1:K1), how do you create a formula to add the # of "X's" in that column/row? For Example: There is an X in cells, B1, B2, B3, B4, & B5; I want a formula to add the x's which would = 5.

I have very limitted use of Excel, but need to create a workbook that tracks $ due to our company based on visits completed. For example, pt # 1 comes in for Visit 1 ($2300.00), Visit 2 ($1600.00), and Visit 3 ($1000.00). On Sheet 1 I want to track the Visits by placing an X in the box meaning...

I work in a hotel in Room Service. What I need to do is create a spreadsheet that will track product in a room by expiration date. For example, a bottle of coke will expire on July 21, I'd like the spreadsheet to alert me that the bottle will expire in 14 days. This way I can get that bottle...