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 Bhavik Joshi Your Own Question
Bhavik Joshi
Bhavik Joshi, Computer Software Engineer
Category: Computer
Satisfied Customers: 463
Experience:  Product Developer at Computer Science Corporation
94617175
Type Your Computer Question Here...
Bhavik Joshi is online now
A new question is answered every 9 seconds

You are familiar with the file we have been working as we

Customer Question

Good afternoon, You are familiar with the file we have been working as we have been working on it just last week. I will ask the next question thinking that you will remember the file or have a copy of it. You already know that when I enter a specific number in cell "A3" that the color of cell "B7" changes to green. OK.......When I enter a specific number in cell "A3", cell "B7" changes to green and I would also like the current time to be entered into cell "H7" AT THE SAME TIME. This time must be STATIC. This time cannot be VOLATILE. So to recap: I enter a specific number in cell "A3" (the number is(###) ###-####, cell "B7" changes to the color green and cell "H7" displays the current time (system clock of course). This time must be STATIC. Let me know your thoughts. Thank you. PS - I would attach a file but the "Attach a photo or file" will not let me do it.
Submitted: 7 months ago.
Category: Computer
Expert:  Bhavik Joshi replied 7 months ago.

Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.

Expert:  Bhavik Joshi replied 7 months ago.

I got your question. It would be good if you could attach your file because I have the first version of your file with me. If required, I can remotely connect as well .

Expert:  Bhavik Joshi replied 7 months ago.

I have changes ready with me.

Expert:  Bhavik Joshi replied 7 months ago.

Please accept this small offer so that I can share it with you securely.

Expert:  Bhavik Joshi replied 7 months ago.

Are you available now ?

Expert:  Bhavik Joshi replied 7 months ago.

I am logging of for now. You can leave your questions/message here if you have any.

Thank you for choosing me!! It really feels special.

Expert:  Bhavik Joshi replied 7 months ago.

I have also added one more code in it which clears the content of column H before we open the sheet.

Customer: replied 7 months ago.
Good morning, Thank you but I do not want the content of column H cleared when it is reopened. I will create a macro to do that when I want it cleared. I have attached the file that you previously created to remind you what was previously created. I had to use ms word because I am unable to successfully send the Excel file to you. I could email it to you if you still need it.
Thank you
Expert:  Bhavik Joshi replied 7 months ago.

You can upload a file to drop box or google drive or Else would you like me to connect to your machine ?

Expert:  Bhavik Joshi replied 7 months ago.

or else you can use http://wikisend.com/

Customer: replied 7 months ago.
I have invited you to share a folder named "Checkin Form" on Dropbox. Is it working? The file we have been working on is in that folder.
Expert:  Bhavik Joshi replied 7 months ago.
Ok
Expert:  Bhavik Joshi replied 7 months ago.
I will modify it.

Related Computer Questions