multiple sheets

This is my scenario. - I have close to 20 worksheets in my Excel file. They have the same header columns. - I need to filter column C, the criteria being a text ("ABC") - This filter needs to go in all the sheets. Can anyone suggest a VB code for this? I am not familiar with VB and codes...

I have an excel spreadsheet with the first sheet that acts as a “template form”. I complete the form, and then run my macro that creates a copy into a new sheet and then clears the data and selections from the template.<o:p></o:p> <o:p></o:p> Every now and then the template needs to be updated...

Hello, This is my first post so please excuse me if I do something wrong. I have a workbook that contains approximately 260 sheets, uniquely named. Each sheet contains a row, say row 22 that is labeled in column A "Review Comments:". Column C through Column Z "MAY" contain text comments i.e...

Hi guys, I am having some issues with Index and Match for a project that I am working on. I have a list of employees where I wish to gather data to calculate their targets. Where I get stuck is the source table is not setup the way a typical index table would be. Column A has the employees...

Situation: I have a spreadsheet I use to track tenants and payments, balance due, etc. Each month (12 sheets) a balance due column is figured based on charges and payments for that month plus the balance carryover from the previous month (if any). Each row is by address, but tenants change...

I have the above in 53 worksheets called Week1 etc. This is using Excel 2003. How do I use LOOKUP (not VLOOKUP or HLOOKUP) to view the data in a Monthly sheet where the columns and rows are swapped? I need a Month1 sheet which has the dates in A1 to A31 (changes for each month) and I need...

Hi all! I have a question regarding on how to get multiple values from different sheets with multiple criteria. What i basically want to do is the following thing: I have multiple weeks (Week 1-52) in all these weeks i fill in the hours that i've been busy on a project with a certain sub-task...

Hi, I need to search multiple sheets on excel and bring the data into a single sheet. I have 10+ sheets like the example below. <colgroup><col span="2"><col><col span="5"><col><col><col><col></colgroup><tbody> Tracy Reference No. Client Review Area % Done Loan Count...

Hi all, I am new here - and relatively new in XL programming. - I have a workbook with 43 different tabs. - Each Tab contains a table with same headers i.e. : Tab1: row 5 : A5: Header1 B5: Header2 C5: Header3 D5: Header4 Tab2: row5: A5: Header1 B5: Header2 C5...

Hi there, Hoping someone can help. I have a workbook with hundreds of sheets and I want to copy only for the ones with a "," in the sheet name. (These are the sheets with peoples names, one sheet per person) All sheets are formatted the exact same way but the headers for row 2 through 33 are in...

Hi all-- I have an extensive formula that works well, until I filter the results. Hope someone can give me some assistance in shortening the formula (if possible) as well as getting the filtered results. Here is a sample of the formula that I am currently using...

I am gonna try to make the question simpler (so only one reference is required) the actual sheet has 54 reference columns. Sheet 1 Column A: Agent ID Column B: Agent Name Column C: Agent Region Column D: Member ID Column E: Member First Name.... Sheet 2 Column A: Member ID Up till now i...

I am using this formula =SLOPE('2012:2017'!$A$2,'2012:2017'!B61) to calculate the slope of a line. The sheets, 2012, 2013....2017 contains the data entry. The cell A2 in each sheet contains the x coordinates that are common and then B61 contains the first set of y coordinates that I want to...

I have a workbook with 100+ sheets. Each sheet represent a time point. I would like to plot the averages of the values for each time point. This clearly doesn't work by just expanding the table, so is there a solution to this problem? Secondly, each time point sheet is actually a table of...

Hi Again VBA Experts, I am trying to select all sheets in my workbook after and inclusive of Sheets("ps"), then format each sheet. I have the following code. It selects all sheets, all sheets widen to 100, but only the first sheet (ps) is then reformatted to Autofit. Can you please point out...

I have two sheets set up, they are named "Quotes" and "Sales Orders" and the information I want to start copying from the "Quotes" and pasting to the "Sales Orders". The data starts in the range of A3 - O3. I would like to have the sheet automatically copy that entire range if the contents of...

Beginner vba user here on Excel 2013. I am creating a user form with two different combo boxes that draw from two different sheets within the same workbook. I have a last row function included for each combo box as the ranges may change from time to time. Here is my code: Sub...

Hello, I'm trying to create a macro in VBA which should convert all cells from B2 and downwards into mutiple columns. I got 8 sheets called D1, D2, ..., D8 - which all need to be affected by this macro. The character to seperate will be a comma. The macro will seperate dates from each other...

Working on a project, and I need to count how many times different keywords are entered across sheets. I know I could just Click on each sheet and select each individual title, but that isn't efficient because I have to deal with over 100 different data points over a years worth of data. Is...

So I need to compute the average number of days between two columns, with multiple instances of each start and end date, across multiple sheets, and only including cells that occur in a row with a matching value. =AVERAGE(DAYS(IF(MATCH(B4,INDIRECT("'" &SHEETLIST& "'!$B3:$B300")),INDIRECT("'"...