summary of data

  1. G

    Display supporting data of a summary cell

    I have a large data source tab that is used across multiple report tabs. Within each tab each office has a summary cells with a number of sumifs and countifs statements. users need the ability to select the summary cell and see the data elements on the data source tab that are part of the...
  2. P

    Can I Summarise Dataset with VBA?

    Hi, I have a large dataset of two columns. The first column is a count 1,2,3,4 etc and the second has a range of variable integers. There are hundreds of thousands of data entries in my complete dataset. Please can I get advise as to whether it is possible to summarise this dataset with VBA...
  3. P

    Refine VBA code to summarise by max values

    Hello there! I have an existing code which creates a summary table from a dataset by counting the number of repeated consecutive values. If there is a new value in the dataset then a new row is created for it in the summary table. Please can you advise if it’s possible to edit this macro (or...
  4. P

    Possible to use VBA to summarise a data table in order of data entry?

    Hi, Please can I get advice on whether it is possible to use VBA to create a summary table from a 2 column dataset as follows: The input data is a simple list of integer 'values' between 1 and 15. The output data should count the number of identical values in a row, give the start and end...
  5. M

    Combining lines from several files within folder via IF or similar

    Hi. I have a need to make a script, that opens and looks through all files within a selected folder. In each file, it should look for a certain IF sentence. If the cell in the line of the specific file = TRUE, it should copy these lines to a new file. The idea is to add and collect all the...
  6. S

    Is it possible to FORCE a pivot table to keep old data?

    I have read a number of posts about changing the "retain items deleted from the data source" setting. This may work well for getting rid of the old data, but it setting it to Automatic or Max does not seem to FORCE the pivot table to keep old data. I am looking for a non-macro...
  7. I

    Summary Report

    Hi, I have a multi sheets tab in a workbook as you can see the name of sheets . i want when i click on the sheet name of any one the data show me of that sheet . than i can sort out by Last name as showing " Braaf "... Many Thanks A Column <tbody> Sheets Name HV-Agewell beg...
  8. Z

    Need a summary of work by dates and counts of the date entries

    Hi, I need help with excel. I have database of my daily work tasks which includes different dates in one column and in the other columns I have other datas that are mostly in text. Now I need an excel code/function that can provide a "summary of tasks" that I did by each date listed and a...
  9. M

    Exec Summary creation

    I have a spread sheet of vacant billets that is primarily organized by offices/sub-offices and then organized by statuses. I have been requested, to provide an executive summary for all of the sub-offices that shows the status of each vacant billet by status and by sub-office (See Below). So...
  10. T

    VBA to Create Summary Sheet

    Hello. I'm looking to create a VBA code that will loop through every worksheet within my workbook (except for the summary sheet) and search for a text string. Once this string is found, I would like the code to grab the 5 cell rows to the right of the looked up cell and paste special this...
  11. F

    Pivot Table: Count number of column values within each unique sub_class expressed by class

    Hi Mr. Excel, I need some Excel Pivot Table help, I'm not quite sure how to express this question in technically appropriate language so I've create the below illustration. Considering the below table, is there an elegant way to count (not sum) using a pivot table, the number of seeded foods...
  12. A

    Need help on multi-level pivot summry

    Hi all, I need help on a survey table that is of following format. Sr# contains 318 rows and there are 30 columns named 1 through 30. I want to create a summary using 'pivot table' that helps me in identifying how many questions have an answer 'a', 'b', 'c', 'd', and '0'. Would appreciate a...
  13. M

    Creating an evolving table of averages from a growing list

    I have an ever-growing master list of values and a table to summarize the list using sumif and averageif functions. I am hoping that there is a way to make the summary table update as the master list grows longer without going back into the function and expanding the cells that the sumif and...
  14. M

    Macro for copying cells from multiple workbooks

    I am new to this forum and I would be very thankful if anyone can help me out. I need a code that will copy certain cells from all sheets of all files in a folder and then list/paste them down in another master/summary sheet. All workbooks in the folder have multiple sheets and in each sheet the...
  15. M

    Creating a summary sheet based on other sheets

    I have excel file in which each sheet will be filled by a different clients (Client1, Client 2, Client 3.. Client n). Each sheet will have two columns "Description" and "Quantity". Client will add the descriptions and quantity.Apart from the sheets filled by clients, the file will also have a...
  16. L

    Summary Box Macro? For inventory system.

    I keep a simple inventory system at work. A row is added for each new unit of inventory. A summary box is used to calculate current inventory and total units processed. Is it possible to set a macro that will auto calculate the summary box when new rows/inventory is added? Currently I drag the...
  17. L

    summarize monthly dates with categories and totals

    Hello all. I have a spreadsheet with three columns. Date, Amount, Category I have dates ranging from January 1, 2011 to May 31, 2011. I have to create a summary by month for each category and the total. Eg, Jan - Travel - $230.00 Feb - Entertain - $600.00 etc. How do I do this?
  18. M

    Help with Query, either VBA or Regular

    Hello again. I am working right now on generating a report but I am unsure of how to do it. Essentially, I am wanting to cycle through a query that I have already built to find the names of the reps (varies as to the amount) and then show the record info associated with that rep. That much I can...
  19. A

    Super Hard Problem.......i think

    This is kinda complicated and im not sure if it's an excel or VBA question but here goes! I work at a home care company and we are redoing out client care plan form which is composed of many check boxes for tasks the caregiver needs to do in the home. PROBLEM: I am trying to create a report...
  20. F

    Summary sheet from data in other sheets

    Wondering if anyone can help me create a formula, command and/or macro for this problem... I have several sheets within one excel document - each has several columns of data pertaining to customers. Particularly, I would like to list all the customers (multiple duplicate listings) from three...

Some videos you may like

This Week's Hot Topics

Top