summary of data

  1. B

    change summary from daily to monthly

    I have an excel sheet that has a row for each day. Each day has the total of cars that have exceed the speed limit as recorded in our speed sign. 2 columns have a date/time that is in MM/DD/YYYY format and a count of cars exceeding the speed limit and has approx. 3 years of data. The end goal is...
  2. E

    How to efficiently have a summary sheet that reads from multiple sheets

    Hi everyone - I was recommended to look for VBA ideas in this forum. The situation: I have multiple sheets that contain data of fixed income assets. These sheets have some data that are input manually (amounts, cost, etc.) and some read from bloomberg ( price, yield, etc), and I have a summary...
  3. M

    Summarizing data for multiple locations based on drop down result

    I've developed a workbook to calculate pricing. Pricing for labor differs based on location - there are 4 locations. A location is chosen and then labor rates auto populate the worksheet(s) based on the chosen location. The location is a drop down list with results 1,2,3,4 in cell M3. (City1...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back