summary sheet

Hello All and thanks in advance for any help. My organization decided to pull the plug on an project tracker database and put my team in a bind and we need to go back to excel real quick . Each team member has a master workbook that could contain anywhere from 5-25 tabs ( for for each open...

Dear Community, I am very new to excel and in urgent need of your help because I have a huge set of Data to analyze. I have a file with a lot of worksheets (>50) that have all their content arranged in the same way. However, they are named differently (not Sheet1, Sheet2 but e.g. P1_F, P2_F...

Hi all, I am working on something to help me analyze a bunch of queries in an Access database. To motivate this I exported all the queries to .csv in a particular folder. I want the output to be in a format so that I can filter on the query and pull up the associated SQL statements for quick...

A fairly complex bit of coding here - hats off to anyone able to do it. :cool: I have multiple workbooks in a specified folder that I need to summarise in a summary workbook. These workbooks contain data in 5 categories on one sheet (capital, resource, etc), and I need to summarise each...

Hi guys, I have the attached billing template. Now, I need to make a summary sheet for it. This summary sheet would have a name filter. For example, if I filter "Joe's" name, it would show data for Joe from all other worksheets. Can you please help me with this? By the way, I can't post the...

Hi All, I am working on a large project to determine all of the different fields that appear within a particular software system. I have a worksheet for every screen, with each worksheet detailing the Field names, along with other information. I am looking to create a Master worksheet if it...

Hello All, I have taken over a workbook and it looks absolutely messy. I need to be able to delete rows from the summary sheet of the workbook, without compromising the data on the other sheets. How can I do this?

Good morning everyone - hope you're looking forward to the weekend. If any of you have a moment to help, I would be deeply grateful. Not being a VBA expert, and attempting to steal code from the internet has only left me in a greater pickle! I will attempt to describe the spreadsheet I have...

Hi all, I've found things similar and I keep having problems mapping them to my exact situation. I'm trying to create a "summary page". I have a bunch of different sheets, and in those sheets column J is a drop down box. So if column J doesn't equal "approved" and it isn't blank, I want to copy...

Dear Experts, Thanks for giving your valuable time. The problem is that i have to prepare a summary of time-sheet based on the working hours (hours worked is based on time i.e. 04:00 - 08:00 & 13:00 - 17:00 etc.). It is really difficult for me to explain in here without attaching the file...

I need to summarize the sheet with sheet name as " Summary sheet" with hyperlink. In the below code , it is summarize but file name is not proper and i need to do manually the hyperlink. Private Sub ListSheets() 'list of sheet names starting at A1 Dim Rng As Range Dim i As Integer...

I have about 100 tab-delimited data files. All are the same number of columns, but different lengths (rows). All are in one directory (call it C:data). The file name is the date and time (140914-074512.dat). I would like to import them to a single Excel workbook, each file on a different...

Hi, I hope someone can help me with the best solution for this. I have a tab that contains thousands of different records, both rows and columns. I want to create a summary sheet that only gives me certain columns and based on 2 lookup values. The user would change these 2 values to suit...

Hello,I have a worksheet that contains 40 sheets.Those sheets have the same header (column A till Q). The data in those sheets will be added consecutively. An additional sheet was created at the beginning of the workbook, which should serve as a summary one. It should contain the data present in...

Hello everyone. I posted this question on another Excel forum last week and no one has responded. :( So here goes nothing... Here at work as a Project Manager, I have been working on redesigning a spreadsheet that tracks the corporation's current projects individually, and displays each...

Hi forum members, I am obviously lacking in the VBA knowledge department, and am trying to create a summary sheet consisting of data that is collected from five other worksheets in the same workbook. On the sheets the data is being collected from I am checking various named ranges for the...

I created a pivot table generated from a table that uses a source file but only takes the necessary data. I needed to sum how much a person has spent and if they go over a certain amount only then do i need to see the details so I can add to records. I didnt want to have to drill down on each...

Hello, I'm brand new to this forum, and very stuck with excel, so any help wil be greatly appreciated. I have a workbook containing 36 sheets with info on individual birds, each with the bird ID as sheet name, and all with same format. Columns from A to G go; Date, Transmitter, Easting...

Hi all, I have an xls with many different worksheets in it and I want to pull certain rows from each worksheet onto a summary page. Essentially each worksheet is the same format and contains company prospects split by industry, however I only want to pull the active prospects (marked by an A in...

Hello all, Thanks to the help of someone else in this forum I was able to partially solve my dilemma. I have a formula which creates sheets based on a template, and then populate a summary sheet. Unfortunately the columns that the macro fills up are not he correct ones. The macro fills up...