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: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year 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 1 year 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 1 year ago.

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

Customer: replied 1 year ago.
It is an .xlsm file and won't go through.
Expert:  Richard replied 1 year 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 1 year ago.
The file will not upload after a couple of attempts. I will have to abandon this effort.Thank you
Expert:  Richard replied 1 year 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 1 year ago.
http://ge.tt/5Uljg6Y2
Expert:  Richard replied 1 year 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 1 year 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 1 year 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 1 year 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 1 year ago.

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

Customer: replied 1 year ago.
Having trouble with the payment now.
Expert:  Richard replied 1 year ago.

ok, whats the issue you have with it?

Customer: replied 1 year ago.
I've update the CC details three times already and it won't save the three digit security code.
Customer: replied 1 year ago.
I am clicking Accept but it keeps asking me to go to My Account and update the CC
Expert:  Richard replied 1 year 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 1 year ago.
I'm on hold.
Expert:  Richard replied 1 year ago.

ok thanks

Customer: replied 1 year 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 1 year ago.

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

Customer: replied 1 year 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 1 year ago.

ok

Customer: replied 1 year 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 1 year ago.

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

Customer: replied 1 year ago.
of course. I'm not looking for free help. Do you still have access to the spreadsheet?
Expert:  Richard replied 1 year 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 1 year ago.
Let me take care of the payment.Thank you
Expert:  Richard replied 1 year ago.

Thanks Damian, appreciated.

Customer: replied 1 year 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 1 year ago.
I'm call CS again. Sorry.
Customer: replied 1 year ago.
They will investigate. Thank you for our time.

Related Microsoft Office Questions