MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds


  Asked By: Marjorie    Date: Aug 19    Category: MS Office    Views: 1399

I capture data using excel, and I am supposed to anlyse and made
quarterly reports, what is the simplest way.

Secondly I have different sheets for capturing data, is there a way I
can arrange these sheets behind each other so that when I finish
capturing let us say data for sheet one, I press Next button then the
second data capture sheet is invoked.



1 Answer Found

Answer #1    Answered By: Reginald Thomas     Answered On: Aug 19

The 1st question is kind of vague. Look at the built in data  analysis
choices on the tools menu. If those are not what you need, maybe we
can help if you can be more specific.

For the second question, you can record macros of selecting each
sheet, then add buttons to the sheets  and assign the macros to the
buttons. To add buttons, go to View – Toolbars – Forms and you will
see the button  tool. Right click a button to assign a macro to it.

Didn't find what you were looking for? Find more on DATA CAPTURE Or get search suggestion and latest updates.