How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Ryan-CTech Your Own Question

Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 524
Experience:  Expert VBA Programmer.
Type Your Microsoft Office Question Here...
Ryan-CTech is online now
A new question is answered every 9 seconds

I want to make changes to a file that was

This answer was rated:

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.

Hello! Mu name is XXXXX XXXXX I'd be happy to take a look at your spreadsheet for you. Can you please go to:

And upload your file and then return here and post the download link so that I can retrieve it? If it has sensitive data be sure to have it expire quickly and put a password XXXXX it.

Thanks, XXXXX XXXXX monitoring for your response.

If it is ok with Mr Dave I will be happy to modify the code I wrote for you :)
Customer: replied 3 years ago.

Thanks for the reply Dave but It would be great if Yegarboy could answer my question since he knows the story allready.


Go ahead and upload your file to and give me the file id or download link. Then let me know what needs done. :)
Customer: replied 3 years ago.

I have uploaded it

here is the link, let me know if it doesn't work Excell worksheet solution

Ok great, I have it now :)

Fire away with the instructions :)
Customer: replied 3 years ago.

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 think it would be easier to make the Tabs Patient names and instead of Monday thru Friday, add 31 columns. So each Patients tab has a Month of stats. It could even go to 3 months of stats if needed.
Customer: replied 3 years ago.

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


we have a problem then. Excel has a limit of 255 sheets. You would have to have a workbook for every Patient.

I got your edit about the stats to be removed :).

I'm not sure what to do about this.
Customer: replied 3 years ago.

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)

So instead of Monday thru Friday it would be a Pt1 Pt2 ect? That we can do :)
Customer: replied 3 years ago.

Yes, and instead of weeks at the bottom it can be individual days.

D1 - D65

Sounds good. Give me 20 30 minutes :)
Customer: replied 3 years ago.

Great I am going to make lunch for my daughter.


I can't believe it would only take 30 minutes. you rock!

Customer: replied 3 years ago.

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 :)

Contact Customer service :) or Click Rate when I post the answer.

I am nearly finished. I ran into some issues I had to work thru but am progressing nicely.

Hopefully not much longer
Customer: replied 3 years ago.

thanks I will wait until you are done and click rate and if it doesn't work out I will contact customer service

Sounds good :)
Finishing up :)
Customer: replied 3 years ago.

Awesome! thank you again for all your work

You are very welcome.

let me know if anything needs tweaked :)

Sorry it took so long, I had to re-write the entire code and add 30 different events to handle all the data. Whew! :)
Customer: replied 3 years ago.

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


I will add 64 more days and fix the totals but that wasn't included in the original question. Are you ok with adding a bonus for extra work?
Customer: replied 3 years ago.
I think it was in the original question but I am happy to give you a bonus as I am very grateful for all your work
Here ya go :)

Hope this does you well :)
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 524
Experience: Expert VBA Programmer.
Ryan-CTech and 4 other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.

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?

I am so sorry,

Its still there I just turned it off while i finished adding the sheets.

Here ya go. Thanks for the Rating :)
Customer: replied 3 years ago.

Thanks !!!!

You very welcome. Take care :)

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland

Meet The Experts:

  • jstinehelfer


    Information Systems Manager

    Satisfied Customers:

    A+ Comptia Certified computer repair
< Last | Next >
  • jstinehelfer's Avatar


    Information Systems Manager

    Satisfied Customers:

    A+ Comptia Certified computer repair
  • JasonJames122's Avatar


    Computer Enthusiast

    Satisfied Customers:

    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    Computer Software Specialist for more than 10 years
  • The-PC-Guy's Avatar


    Computer Manager

    Satisfied Customers:

    20 years experience providing remote computer support
  • James K.'s Avatar

    James K.


    Satisfied Customers:

    Technical Director of IT Company
  • IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    Bachelor's Degree in Information Technology, Microsoft Certified Professional
  • Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    Certified Expert with over 10 years experience.