multiple sheets

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...

Hello All, I have the VBA script that will copy the active sheet into a new workbook and email it, but I can't figure out to copy multiple sheets into a new workbook and email it. I have tried a few things and I have got the sheets to copy into a new work book, but than it won't send the book...

Good Morning All, My company is working on upgrading their system for tracking their change orders. We have it currently being tracked on paper and then input into a spreadsheet. We need all the data that goes into the tabs RS, DW, and GM TO automatically input into the Sheet1 spreadsheet...