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 Robert M. Your Own Question
Robert M.
Robert M., Consultant
Category: Financial Software
Satisfied Customers: 3069
Experience:  30 yrs. of computer experience in financial and marketing departments.
Type Your Financial Software Question Here...
Robert M. is online now
A new question is answered every 9 seconds

I have 500 sheets in one workbook. They were created with

Customer Question

I have 500 sheets in one workbook.  They were created with a template so all cell references are in the same position on every sheet.  I need to compile stats from the sheets.  I have reports set up in another sheet of the same workbook.  I need the reports to calculate the information in the other 500 sheets. For example:  Report #1 compiles stats for the month of January from the 500 sheets, but I need it to ONLY compile that info from the sheets that have activity in January.  So lets say I set a cell to have an “x”entered into it to indicate that this sheet has January activity.  When that box has an “x” entered then the formula will compile the info needed from other cells in the sheet.  If no “x” then ignore that sheet.  How do I do that?

Submitted: 4 years ago.
Category: Financial Software
Expert:  Rachel-Mod replied 4 years ago.
I'm a moderator for this topic. I've been working hard to find a professionals to assist you with your question , but sometimes finding the right professionals can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!
Customer: replied 4 years ago.

I will wait. I need to know how to do this.

Expert:  Rachel-Mod replied 4 years ago.
Thank you for your patience. We will continue the search for a professional for you.
Customer: replied 4 years ago.

never mind. I figured it out. maybe should cancel my subscription