tabs

Imagine a file with about 20,000 rows and each row has product data. The first column has the product name sorted so all the rows for a particular product are in contiguous rows. I need something to split up all the rows for each product into their own tabs - in this file or a new one. It...

I have a workbook for budgeting construction projects. Each element of a project gets its own tab (for example, walls, roof, floor, etc.). Within each of those tabs the user chooses a category of material from a drop down menu, then the actual material from a second drop down menu. Those drop...

Hi everyone and thanks for taking a look at my question. I would really appreciate any assistance! I have created a sales quote template for my company. Some of our sales people use Macs and other use PCs. When going to print a quote, it is necessary to select three different tabs. Sometimes...

I’m trying to do something like an advanced 3DSum where instead of having all the tabs lined up next to eachother, it refers to a range on the sheet for which tabs to sum. I get pretty close with this: =sumproduct(sum(indirect$AN$10:$AN$15&”!”&cell(“address”,c46)))) Where $AN$10:$AN$15 has a...

Hi - I am working on a VBA to hide and unhide tabs in a single work book. I have a drop that consists of "Low", "Medium", "High", "Major". With the "Low" choice, I want to hide tabs "Key", "Stakeholder Interest Influence", "Stakeholder Mgmt Plan", "Risk Mgmt Plan", and "Quality Mgmt Plan"...

I am trying to consolidate data from 26 workbook of same tabs and same columns into one workbook. All these workbooks contain data in same format and same tabs. I want all the tabs with the same name should merge data together and create one master workbook. Any thoughts on this.

Thank you in anticipation. I have multiple tabs on a worksheet that are ordered thus (the numerals are times but set as text): Bus 14.10 Bus 14.40 Bus 15.10 Car 14.15 Car 14.45 Car 15.15 Plane 14.20 Plane 14.50 Plane 15.20 I would like to sort the tabs in TIME order.

Hi - looking for help I have MI on 3 tabs which I want to easily Copy and Paste into a master tab in month order please https://drive.google.com/open?id=1Q5...1aVd313i3gGa-Z

Hi i'm trying to fill a formula where the reference will sequence the worksheet tabs i.e if worksheet tab 1 is Apr, tab 2 is May etc then by having a formula referring to worksheet Apr and dragging the formula down it will fill the sequential worksheet tabs, is this possible i can't seem to make...

Hi everyone, I'm an educator who is having trouble with some code to write for a task I need to do. I have a spreadsheet with column headings and a first row of data as such: A B C D E F G H I...

Hello, I don't know whether what I am trying to do is possible? I have a summary tab in my spreadsheet that has a number of New and Existing Accounts. I need to have two further separate tabs: one that displays only the new accounts and relevant data associated to that account, and the same...

I have an issue that is similar to the one discussed in the thread at https://www.mrexcel.com/forum/excel-questions/769002-worksheet-cells-dependant-eachother-circular-reference-problem.html; however, it stretches across multiple tabs. This is a spreadsheet used as a statistical scorecard for...

I normally use a basic code that looks into a secondary workbook and scrolls through all that tabs for me (example scroll below). However, what I just realized was that I'm always running this against other macro enabled files. And earlier when I tried it against an ".xlsx" file, it would not...

Hello guys, I need to write a trim macro. I am using the latest excel. I have an excel sheet with a lot of spaces and tabs wherevar I have data in the cells. I need an excel macro to get rid of those spaces and tabs. Can you help me? I couldn't figure by myself how can I write a trim Macro...

Hi Team, I have data in multiple tabs in one workbook like 40-50 tabs and i need only 8 worksheet tab data which is require for my job and my data is available in different tabs like one lies on 2nd tab and another lies on 12 tab...goes on.... Is there any short cut in macros/formula where i...

I have a 50-worksheet workbook from a client that includes specific data within a single cell on each worksheet that I would like to extract. Cell B10 contains three numbers which are added together (ex. "=895+1023+9974".) On a new worksheet, I would like to show three columns by fifty rows of...

Hi all, i need some pointers on a formula im trying to use. I have a workbook with multiple tabs and a summary tab. on the summary tab from A2 - A10, i have the corresponding sheet names. on B2 - I 2 i am using =INDIRECT("'"&$A2&"'!"&"O3") to pull data from the referenced sheet name in A2. My...

Hi, I'm trying to find a medication displayed on sheet 1 within a list of medications (displayed on sheet 3) and output its relevant usage (relevant totals cell displayed on sheet 2) - for example if Allopurinol 100mg tabs is the medication displayed on sheet 1, then the quantity cell should...

As the title reads, i'm looking to see if there is code to break external links only on specific tabs in a workbook. I have found a few codes on this forum, however, they all break external links in the entire workbook - not specific tabs. I can provide these code if necessary. Thank you!