summary

Hi All I am attempting to loop through each sheet in a workbook, find the first blank after "A2" and therefrom create a range. The problem seems to be that whatever sheet the macro is assessing it always finds the value for the first blank on Sheet1 For Each rs In Wb.Sheets...

Hello Everyone I am very new to VBA so i am at a loss with this code i have tried copying existing codes from other posts but havent had any luck as yet. The workbook is essentially a price book and i am trying to create a macro that will copy the text from the woksheet "flexible duct" to the...

Hi all, I've got the following formula combining an index match with a sumif, but it's returning the wrong result. The goal is to sum all the values that equal what is in C8 that match column A on the Niagara Summary page, and then sum the values based on the index match criteria below. The...

Good morning all, i have scoured through MR Excel, and many others but have not had any luck. This maybe due to not using the right keywords in google. Alas, i have had to create this post for help. The best way to describe this issue is something that is done automatically within MS Project...

Hi all, I'm trying to make a pop up box where the message information will change based on variables. I have a database of multiple factors (the 3 I'm currently working with are (Project, report type, frequency) which are unique combination. The summary page shows these 3 factors and several...

Hello, I got a code to By Marcelo Branco, which generate all-possible sets using following layout under this link is superb! The summary below I got generating all combinations with the code and then counting by sum as shown in the Column H:J...

Hello, I have a worksheet with many sheets that i would like to summarize into one sheet. Essentially i want to go through ranges $D$29:$D$39 and copy the list ( which includes a column of cells with texts & values ) however there are duplicates so i don't want the same cell value/text to...

Hi i have huge dump ticketing report which needs to categorized.... there are many key words it has to lookinto in the summary to categorize the data can you tell me if this is possible?

I have a workbook with a Summary page and 5 employee pages: Tabs are: Summary, Name1, Name2...Name5 On the summary page I have columns: Job (which is our job number), Panel (number of hours), Wire (number of hours) ... and others, all numbers of hours. On each of the employee pages I have...

Need help on this issue I have with excel: Sheet 1: master copy with columns of data, A, B, C Sheet 2: summary of minimum value linked from sheet 1, but of only selected cells with no fixed order; eg MIN('sheet1' B2, 'sheet 1' B4, 'sheet 1' B5) However, when I Sort my sheet 1 data, say column...

Hi, I have tables on multiple worksheets that all have the same column headings for each and every column of the table. I was hoping to create a consolidated table on a summary sheet. Is there an easy way to do this automatically without manual copy/paste? Would also like to have the...

Hello All, Need some help. Im looking at a problem summary cell and looking to extract key words. For example if the summary has TRON Then extract TRON. If the Word has TRON or AL2, then give me TRON. If the summary has AL2 then give me AL2. I know there is an OR that goes in my formula but not...

Previous thanks goes to Fluff for figuring out the code I have posted below (about a year ago I did this.) The code works brilliantly, but i am looking to further 'drill down' on the criteria... here is how it currently works: I have a spreadsheet as shown with columns containing the different...

Hi There, Thank you in advance for your help! I have a mass of data on a tab called "Detail". I have another tab (Summary) with a list of names. I need to pull information from the detail tab based upon the name in the "Summary" tab. For example the information on each tab is: Detail Tab...

Hello, I apologize in advance because my question is going to be vague. A year or so ago a collegue sent me an excel workbook which had the ability to click on certain fields wihtin the summary page and the data related to that cell would break out in a new table on a new tab. I have a list of...

Hello, Trying to get a value into sheet A from a cell in either sheet B or C where a cell on either sheet B or C equals a certain cell on sheet A. I have linked the workbook to understand better. Comments are in the summary sheet in cells C13 & E13...

Hi , i am trying to save a multiple sheets from a workbook on to pdf in the same folder where excel workbook is saved, file name with specific cell value below is the code i am using & i am getting, Application-defined or object-defined error, can someone please help on this, i know i am...

Hi All, Been trying to make this work with previous similar questions but unable to make it work. When trying to do this on a summary level the absolute is done on the top level and not on the line by line level and then summed, which is what i am looking for For example If i do a cross grid...

I have several worksheets in my workbook, I need cell A2 to reference the tab or worksheet name of that worksheet. for example, worksheet 1 is called summary in cell a2 I need it to say summary, worksheet 2 is called ALB and need cell a2 in that worksheet to say ALB. Thanks

Hi, Thanks in advance for reading. I am trying to crack a formula to look up multiple criteria and return me the total count value. Brief description: Creating a report for incidents, to show me, the number of incidents per month, which have been open for longer than 7 days and the...