summary of data

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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?