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 NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have a worksheet used the business. There are separate

Customer Question

Hello, I have a worksheet used for evaluating the business. There are separate tabs for each category to be graded with at least 10 questions for per tab/category. Each line has a point value tied to an active x control, yes for a point no for zero point award. Every time a point is missed I want the text of the question to show up automatically on a line in another tab, so if 20 lines were missed I would see those 20 questions summarized on the separate tab. Is this possible to do?
Damian
Submitted: 9 months ago.
Category: Microsoft Office
Expert:  Richard replied 9 months ago.

Hi there Damian and welcome

Can I have a look at your sheet please so I can better judge what your trying to do?

You can attach it here to this question please.

Customer: replied 9 months ago.
Hello,
Here it is. I want any question that is answered no to show up on a new tab I will call Findings.
Expert:  Richard replied 9 months ago.

ok, you gave me a picture of the sheet, can I have the actual Sheet please?

Customer: replied 9 months ago.
It is an .xlsm file and won't go through.
Expert:  Richard replied 9 months ago.

- Click the following link: http://www.wikisend.com

- Upload the file to that website

- Once it is uploaded, the resulting page will display a "File ID" number.

- Please, give me that "File ID Number"

Customer: replied 9 months ago.
The file will not upload after a couple of attempts. I will have to abandon this effort.Thank you
Expert:  Richard replied 9 months ago.

ok, not sure why your having issues with the site, but try on

http://ge.tt

And provide me the download link please

Customer: replied 9 months ago.
http://ge.tt/5Uljg6Y2
Expert:  Richard replied 9 months ago.

ok, so they go through the entire sheet, filling in all Questions on ever Tab and then the ones skipped you want shown on the Findings sheet correct?

And being Skipped means they choose NA?

Customer: replied 9 months ago.
they go through the entire sheet filling all questions either, yes, no or NA. The questions marked no are the ones I want to show automatically on the Findings tab. A sort of summary.
Expert:  Richard replied 9 months ago.

ok, I can do this and have made the amount to reflect the work. It will take a few hours as I will need to develop the code for this.

If you accept it, I will start on it now.

Customer: replied 9 months ago.
I'm not concerned with the NA or skipped questions. Just the "no" questions meaning there was a problem in need of attention.
Expert:  Richard replied 9 months ago.

No problem, if you accept the offer I can do this

Customer: replied 9 months ago.
Having trouble with the payment now.
Expert:  Richard replied 9 months ago.

ok, whats the issue you have with it?

Customer: replied 9 months ago.
I've update the CC details three times already and it won't save the three digit security code.
Customer: replied 9 months ago.
I am clicking Accept but it keeps asking me to go to My Account and update the CC
Expert:  Richard replied 9 months ago.

ok, I am not sure sorry as I cannot see anything about Payment here.

Can you call Customer Service on 1(###) ###-####for this please?

Customer: replied 9 months ago.
I'm on hold.
Expert:  Richard replied 9 months ago.

ok thanks

Customer: replied 9 months ago.
Well CS says my bank is flagging the transaction as fraud because I already tried it a couple of times. I would need to call the bank to give permission.I'm just going to go ahead and close off this transaction. I appreciate your time.Damian
Expert:  Richard replied 9 months ago.

ok, thats a pity as its the first I have heard of having issues to pay, but no problem

Customer: replied 9 months ago.
I'm not sure what happened either. CS says the $48 went through fine the first trans.Please discard my spreadsheet.Thanks again
Expert:  Richard replied 9 months ago.

ok

Customer: replied 9 months ago.
Hello. Are you still interested in picking up this task? I don't see anyone else has offered to take it.Damian
Expert:  Richard replied 9 months ago.

Once the additional services is accepted I am Damian as I believe its fair to be compensated for the work done.

Customer: replied 9 months ago.
of course. I'm not looking for free help. Do you still have access to the spreadsheet?
Expert:  Richard replied 9 months ago.

yes I do, I have a copy for when the payment comes through so I can start working on it asap for you.

Customer: replied 9 months ago.
Let me take care of the payment.Thank you
Expert:  Richard replied 9 months ago.

Thanks Damian, appreciated.

Customer: replied 9 months ago.
My apologies. Is there another way of getting payment to you? I've used another CC and it doesn't work either. Paypal maybe? I don't know what the problem is.
Customer: replied 9 months ago.
I'm call CS again. Sorry.
Customer: replied 9 months ago.
They will investigate. Thank you for our time.