Microsoft Office Questions? Ask a IT Expert for Support ASAP
I want to make changes to a file that was created for me previously on just answer.
I have an excel file that is for collecting stats and and I want to change some things. Currently the file has tabs for weeks and the days of the week are the columns. I would like to change it to the tabs for the day and each column is for individual pts I see daily. It will be many more tabs and columns. The extra part that was done by Yegarboy (the last person who helped me on just answer) is a macro that enables me to click on the items and then it adds the information directly to the excel sheet.
I guess I have been a little impatient. I got my answer so quickly last time but it wasn't on a weekend. I hope someone can help.
Thanks for the reply Dave but It would be great if Yegarboy could answer my question since he knows the story allready.
I have uploaded it
here is the link, let me know if it doesn't work
http://wikisend.com/download/425536/New Excell worksheet solution #1.zip
So what I would like to do is enter the data for each patient I see instead of entering it in at the end of the day. The function to do it as the day goes with the way it is now is not great. I have also talked to my collegues and they don't want to use it so I am going to get rid of some of the rows of data that are a bit irrelevant for me.
So my idea is to change the tabs at the bottom instead of being weekly to daily ( day 1,day2 etc for 3 months) and on day have 30 columns (one for each patient I might see in a day)
Or do you think it would be better to just make all the tabs patients and just skip the days of the week. I estimate that the max number of pts I might see in a month would be 300 but I need to collect data for 3 months.
If this is going to be a nightmare for you please let me know
I will send you a list of the data I want to keep in the rows in just a sec
I am a little confused, So each tab at the bottom would be Pt #1, Pt #2 etc
I would need a total of 300 pt per month so 900 for my total stats would that be 900 tabs at the bottom of the pg?
did you get my edit about the row data?
The rows that are in red are the only ones I really need with the exception of Row #7 (pts seen outside the clinic) this one should be in red also
what if we go back to my original idea that each tab at the bottom in a different day and then instead of the days of the week inside the tab it is pt#1 - P#30 (I don't usually see more than 15/day but 30 would be the max I can even imagine)
Yes, and instead of weeks at the bottom it can be individual days.
D1 - D65
Great I am going to make lunch for my daughter.
I can't believe it would only take 30 minutes. you rock!
about 10 min before you replied to my question I asked for refund and I just got the confirmation, I assumed it was cancelled since you were replying to me. How do I start the payment again. I don't want to lose you today :)
thanks I will wait until you are done and click rate and if it doesn't work out I will contact customer service
Awesome! thank you again for all your work
Sorry but there is some things that still need to be tweeked.
first I need to have more days, ideally 65 (for 3 months worth of data) (as I implied earlier this might be a nightmare for you) So there would be 30pts per day for 65 days
Also the totals page does not seem to be working
Hi, it looks like it is all working well, I guess what I was asking for was something that is way more than just one question. I was hoping that the macros would still be there But I guess that would be too much work eh?
If I offered to give you more of a bonus would you be able to do it?