25 thoughts on “Excel Magic Trick #506: Summarize Data – Multiple Sheets & Banks Accounts – Checkbook Register”

  2. I do not understand your question. Can you give me more detail about 1) how data is set up, 2) what your goal is, 3) what the end result is, and 4) an example?

  3. Hi there i am trying to get the frequency values from another page and do the sum on my main page but it never works properly.. can you give me any tips?

  5. Probably a really hard nasty array formula is required.

    You will have to go to the Playlist titled:

    Excel Extract Records From Database Table / List

    there are Filter, Advanced Filter and Array Formula solutions.

  6. This tutorial is really helpful. What i want is not sum up the total but just have what ever data i alreay have just populate depending on what ever year i select.

  8. Data Validation help required please.

    I have sales months (Jan-dec) in columns B – M and sales reps in rows and have the total sold populated inside the table. I have this for 2005 – 2009 on each sheet

    all the sales are on each sheet

    What i want to do is have a data validation 2005 – 2009 and what ever year i select, i want all the sales to be populated for that year.

    What formula can i use, Thanks

  10. SEARCH is not case sensitive, FIND is.

    Here is what I know:

    Excel Magic Trick 292: Reverse Last & First Name Tricks

    Excel Magic Trick #192: Extract Middle Name Text To Column

    Excel Magic Trick #191: Extract Middle Name Formula

    Highline Excel Class 13: Text functions & AMPERSAND

    Excel Magic Trick #190: Rearrange First Last Name w Formula

    Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

  11. It totally depends on what data you have, how it is set up, whet goal is. Here are some videos:

    Excel Magic Trick 292: Reverse Last & First Name Tricks

    Excel Magic Trick #192: Extract Middle Name Text To Column

    Excel Magic Trick #191: Extract Middle Name Formula

    Highline Excel Class 13: Text functions & AMPERSAND

    Excel Magic Trick #190: Rearrange First Last Name w Formula

    Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters

  12. STEVEN JOHN PAUL GERRARD
    MICHAEL JOHN H ANTHONY SMITH
    SHAUN H NORMAN
    ROGER CLARK

    What is the best method/easiest formula to extract any middle names and what’s the difference between the search and find?

    Are there any videos on this type of scenario?

    gracias

  13. Hi,

    I have seen many different ways to extract middle names and last names. Some are really confusing to figure out.

    Some people use find and others use search to find a pattern occuring.

    What is the best and easist way/formula to use to extract middle and last names. I guess the first name is pretty easy as everyone seems to extract the first name using the same formula. What if there is 1,2 or more middle names…i,e

  15. No but I have learned a ton of great tricks from you videos that I’ve used at work. Most recently I’ve utilized that VLOOKUP function. Boy that is a great thing to know. Thank you for all the work you put into these videos.

  17. I do not know how to do that. The best Excel resource is:

    Mr Excel Message Board

    mrexcel[dot]com/forum

    I I have commenetd in about 200 of the 1000 videos posted – THE SMARTEST EXCEL PEOPLE IN THE WORLD HANG OUT AT THIS SITE!!!

  18. Is there a formula/trick etc.. where i can copy and paste on each sheet but have the dates change/added by a week and also have the sheet name change automatically to WC 15/02/2009, WC 22/02/2009 ETC…

    SO SHEET 1 (WC 15/02/2009)
    SHEET 2 (WC 22/02/209)
    SHEET 3 WC 29/02/2009)

    So just to make it clear i want to copy and paste accross the same data for each week but have the dates increment by week to week automatically and also have the sheet tab name change to the WC etc…

    Thanks

  19. I have several of other data i.e employee names, start times, finish times etc….but the main thing i want is have the same data copied accross but have the week change from 15/02/09 – 20/02/2009 to 22/02/2009 – 27/02/2009. So basically as you can imagine i am doing a weekly roster but its a pain to keep copying and pasting and having to change the dates manually.

  20. Cool thank you

    I need some help. Please

    I am trying to do a weekly roster for work.

    So just say Column A1-E1 i have todays date (15/02/2009) Monday in Column A1 and i have the rest of the days for the week added accross to E1 therefore in Column E1 the date is (20/02/2009) Saturday. (Sunday is a non rostered day).

  22. Hi

    You will definately be the man to know. Can you explain what all the charts are in excel. There are many charts i.e gannt chart, bar charts, line charts, pie charts etc… but i dont know what charts are used to analyse what type of query or when to use what charts to analyse data.. I.e when do we use a bar chart, when do we use pie charts, when do we use the gannt chart etc….

    Thank You

  24. It probably won’t happen any time soon. But that doesn’t matter. You can teach yourself the Excel Basics, then forget template that are already made, just make your own. Watch these playlists to get the basics:

    Excel Basics Series

    Highline Excel Class Beg – Adv (Complete Class – 59 videos)

    Do you know how to find the playlists?

  25. Thank you for your quick response. Your videos are great. If you could format the videos you have done already on Financial Statements or do some more videos on balance sheets, income statement, profit and loss and cash flow, acc’s receivable, depreciation formulas/templates etc.. that would be fab. You sure have made Excel Fun

Leave a Reply