summary

Hi, I'm wanting to be able to create some summaries based on existing data. In Column A is the start time of an activity E.g 10:00 and Column B is the end time E.g 12:30. I'm wanting to create summaries by hour to show much time is spent each hour. For example, the above case would count one...

Hi Below is the excel file. I am looking to get a pivot or summarize the result. The sales data is by month and region. Salespersons are identified in a mapping table. Trying to find an easy way to summarize. In real life example, regions are not 4 but variable is 100s. So dont want to use...

Hello, I have a spreadsheet where I want to pull rows 11-17 from each tab into a summary sheet. All of the tabs have the same structure, but different data for each market, so I'm trying pull it all into one data source. Can anyone advise on how I can do this with VBA? Thanks!

Morning, Long time reader, first time poster. Looking for some help with a formula, or If it is even possible. I have a sheet that is a summary overview screen. It pullsdata using drop down list from other sheets to display financial performance. The summary screen shows the 11 key...

Could someone help me write a script that will automatically hide rows on a "Summary" worksheet base on selections made from a "List" worksheet. The calculated values in column A ("QTY") on the "Summary" worksheet are "" when not selected from the "List" worksheet. I found some script that I...

hi, im wondering if there's a way via vba to delete any sheets to the right of the "summary" tab in my workbook.

Hi, I have a userform with several textboxes and a submit button. My goal is to show a summary box of all entered data when the submit button is clicked. Below is the code that I have but is not working. Thanks for the help! Private Sub CommandButton1_Click() Summary.Show End Sub...

I have 2,000 spreadsheets in a folder - I would like some code that; - opens each spreadsheet one at a time - in sheet "Summary", copy/paste special whole sheet - in sheet "Summary", columns C&D - I only want the first letter of any text to remain (converting names to initials) - delete all...

Hi all, I am trying to add a summary screen to one of my workbooks to make it a little clearer to those who assess the data, but don't enter it. My tab for the raw data is called 'Ongoing' and the tab that I am trying to return the data to is called 'Summary' In essence, I am trying to get a...

Hi, I’m in the process of developing a reporting template and have become stuck. I’m working with a fixed report format and so have to produce a summary from separate tabs. I need to calculate the total spend for a specific quarter or year, depending on the value chooses from a drop down...

Hi All, I’m trying to write a macro to populate a summary sheet. The Summary sheet lists rows from sheets in the same workbook, depending on a drop down box for each line in the source sheets. If the a specific cell on source sheet 1 says yes, that entire row is to be pasted into the summary...

On sheets 1 through 30 representing each day of the month I have data that I would like to transfer to the Summary sheet. so for example I have '1'!A2 as a formula on the summary sheet and when i type it in, it seems to work but when I delete out all the data on sheet '1' and copy and paste the...

Hi all, Hopefully this is possible. I have a workbook containing around 100 or so sheets. The first sheet is the summary sheet, that contains amounts owed by each customer. These are displayed as a list from top to bottom, with the amounts owed beside each name in the adjacent column. What I...

I have a worksheet named for a specific date. The date can also be found in cell A1. I want to copy a column of the data in this worksheet to a column in a summary worksheet with the same date (same workbook). I can find the column number of the column I want to select in the summary...

Hi all, I always thought that I was rather skilled at working with Excel, but I’ve got me a ‘problem’ that I can’t fix by myself. Looking at the topics and solutions offered on this forum I’m merely a novice compared to what some people can do. Therefore: Any help would be much appreciated...

Hi, I have over 100 worksheets that have the same table (same dimensions, in the same location), and I want to create a summary table on another worksheet that sums each cells value. Looping through the worksheets is far too slow, and I'm sure there is a better solution. Outside of VBA I...

I understand the basic idea of using Indirect to create dependent drop down lists. However, I'm aiming for a more user friendly interface. I am trying to create a budget workbook that includes a summary income table and summary expense table. Income Table <tbody> Account Account Name Budget...

Hi everyone, I have a sheet with multiple tabs, and they all contain data exept one that is the summary tab. The summary tab has a max formula to look across all tabs, and that works great. My problem is that at the bottom of every data tab is a grand total, and this is what the formula is...

I have a workbook with multiple sheets. The first sheet is a summary, and the following sheets are used for adding new data. I have a macro to convert one data sheet and the summary sheet to a pdf. I would like the data sheet to be first, and the summary to follow, but I can't seem to get...

Hi All, I have a real head-scratcher here. I have a workbook that is being used for document training courses. In it, there are two worksheets: The Data worksheet contains the location of training, trainer, trainee and course data. It is formatted to "look nice". The Summary worksheet contains a...