multiple sheets

Hi, let me start by saying I don't know much about excel. I don't work with it regularly but I was asked to try and figure something out for my boss. I have exported data from two separate sources, there is very little in common between the two except for the customer names and the amounts...

I have several sheets (each a project sheet), and two aggregated sheets that would represent 2 companies (each company aggregating part of the projects). On each aggregated sheet (company) I want to sum the production of the projects that corresponds to it. So, I've started something like...

Hello, I am trying to create an excel file that will be shared with another user. I need the user to select certain responses on one of three sheets in the same workbook. I have 3 tabs named "Full View" "Customer View" and "Product View" all showing the same information but in different...

Hi all, I have the following topic that I cannot take a step further: I need to summarize data from 3 tabs into a table based on multiple criteria and as it can be seen below I have created 3 different sumifs. The index matches the month, and then follow the 2 criteria. My goal is to reduce...

Hello, I have the same data repeated across several sheets. Example: In Sheet 1 which I named Risk Review in cell A3 I have 'Analyst Name' and then in B3, text should be entered. In Sheet 2 (renamed Walkthrough) I have 'Analyst Name' in A6, and then text should be entered in B6. What I'm...

Hello all, I am tracking hours over the year with the weekly hours total placed in cell M3. In cell N3 I have this equation =AVERAGE('WEEK 1:MASTER'!M3) which is keeping a year to date average of hours. which is working great, except if I add a new person to the sheet to track the hours, the...

The description probably does not explain what I am trying to do. I am trying to create a dynamic roadmap based on data in two other worksheets. In the attached document I want Roadmap:B to display the appropriate RefCode value from Quantitative:A OR Qualitative:A IF the Objective field...

Sheet2 contains more than 200000 rows (with unique strings in Column A and B). I would like to search 1 to 3 keywords from Sheet1, Keywords in B1,B2,B3 and get all matching cells from Column A from Sheet2 to Sheet1, starting with Cells A5. For Column B (B5 onwards), I am using vlookup to get...

Hi All I was hoping to find a way to count a specific criteria across 72 sheets without using =SUMPRODUCT(COUNTIF(INDIRECT("'"&tabs!$A$1:$A$72&"'!C:C"),B2)),"") etc These are the facts in my case -I have circa 40k loans in one sheet, each which has a unique reference code. -For each loan, i...

Hey, I am analysing data. Taking 3 columns, and putting them into a new workbook. Saving, then closing. the code works fine, but I can't get it to loop through worksheets. I've tried several of the suggested methods and none of them have worked on my system. I tested them using...

I have three sheets a budget, actuals , and then a performance sheet (the difference between what we budgeted and what we spent). Each are divided by months and expenses. The equation is =SUM(Budget:Actuals!B6). I want to make it so cells in the performance sheet don't populate if there is a...

I have created a list of potential "skill sets" that leadership in my company may want to track. Now I have sent this list out to the leadership for review. The list is set up in the following manner: Skills down the 1st column. Career fields/specialty across the first row. Now I am asking...

Hi - I am attempting to come up with a code to copy a varying number of rows from a "Template" worksheet to multiple sheets in my workbook depending on a cell reference on each sheet. So, for each sheet in the workbook that begins with "Labor BOE", look at the number in cell "L2", copy that...

This seems like a fairly easy operation, but I haven't found a working formula. Also, I know I have layers of complexity, which is why I am turning to you wonderful people for help! Data Source: On my main tab/sheet, I have a table with a list of Property Names in column 'A'. Moving across...

Hi all, I am trying to combine sets of rows from two sheets. Here's a brief illustration of the desired product: Sheet 3 Rows 1-5 of Sheet 1 Rows 1-5 of Sheet 2 Rows 6-10 of Sheet 1 Rows 6-10 of Sheet 2 ...continuing in sets of five I'm currently using the following formula...

Hi all, I have got a printing project that I am trying to save days worth of time in. Currently I have a list of contents in 'Sheet1' (example below): <tbody> A B C D E 2016.2017 New ABC123 Yes Full 2016.2017 Old ABC123 No Half 2016.2017 New DEF456 No Half 2016.2017 New DEF456 No...

I have a workbook with multiple sheets that each contain a table with two columns: an 'acronym column' and a 'description column'. This table takes place in columns 'F' and 'G' of each page. On my title page I'm looking to have a button that launches a Userform that will allow the user to input...

Hello, I'm trying to perform a 'search box' function in my excel workbook. I have a workbook with 27 pages in it, the first is a cover page of sorts and the others contain tables with tables with text - each other page relating to a different letter of the alphabet adn called 'A', 'B', 'C'...

Not sure if this can be done or not. I am trying to find the 5 largest values across all worksheets. The range is the same for each worksheet. I want to return those values (the 5 largest) as well as some other values from the related ranges. I can use the LARGE function to return the largest...

Hello, I have a macro that broke down an Excel workbook into multiple saved files based on a sheet range, beginning with a defined sheet name and ending the sheet before another defined sheet name. I recently updated to Excel 2016 and the loop I have to select the sheets in the range is not...