tabs

I created a workbook 3 years ago and since then each month I have been adding a new tab. I currently have about 36 tabs. All tabs are identical size which they are from A1 to AP69. Not every cell has data but most of cells has something in it so I don't think it is necessarily a big file. Every...

Hi, I have multiple (hundreds) of archived spreadsheets consisting of the same mix of tabs and content format (only the data is different). I want to add an extra tab (lets call it 'Tracker') to pull bits of data from the various tabs into one easy to copy n paste column. Simple. :) What I then...

Hi, I am currently working on a worksheet, and on the sheet there are 4 tabs which have the same layout but each is a different cost centre. I need to do a check to see if one number on a master tabappears on any of the 4 cost centre tabs. Basically I need a vlookup across the 4 tabs but in...

I built a macro in Excel 2010 that does a Vlookup from one spreadsheet to another, and when the macro is run, a popup box appears and lets the user click which tab they want the macro to perform the Vlookup on. I used the following code and it was simple and very effective. Dim cbTool as...

Hi, I want to use a macro to create multiple tabs based on a slicer. The sheet will have all the other slicers and also graphs based on the particular slicer. I have 3 graphs and 4 slicers - the slicer which I want to use to populate the tabs is countries. So each country has their data on a...

I am creating a budget template. I am sharing it with two others but they haven't added any restrictions. For some reason, I can no longer click certain features in Excel (such as add border or font color). The workbook does have a macro which locks each of the three tabs when the file is opened...

HI, I have an excel with 2 columns. Column A = Name Column B = 'URL' (www.google.com) Not all Column A's have URL field. some are blank. I want to create new tabs in the same excel and seperate out URL and NO URL data. Please advise.

Hi all, is there a work around for coloring a tab in a shared workbook. i have a workbook which myself and another share for my supplier accounts and the tabs are colored depending on if they need to be actioned. i update them by coloring the tabs Red, Orange & Green on the tabs themselves and...

I need assistance writing a formula that will capture data from 3 tabs sheet1,sheet2,sheet3. On each of these tabs I need to account only for data that is in the month of June which is in column C and where column F has a Y response and then divide all 3 of those by the total number of entries...

I have a Workbook with tabs and each tab contains a table. Each table is the same format (Column A is ColA, Column B is ColB, etc). One of my tabs is a dashboard, where I want to retrieve values from each tab: Dashboard tab Column H will look into table Data-A and return the value of Column H...

Hi, I have a spreadsheet in which I post daily data for up to 50 employees. I have a Macro that combines the data from 2 tabs into 1 sheet and creates a copy of it. I save that copy with the day. I want to create a MTD sheet that will sum up all of the fields from the daily tabs that are...

Does anyone know if there is code to lock the ribbon so that none of the tabs can be selected? Or even hidden and locked?

Hello all, thanks in advance. I've tried tons of formulas and combinations but no success. It doesn't matter if I have to add the tab name for each section of the formula or if there's a way to get every tab's names without mention it in the formula. No VBA please (unfortunately). I'm trying...

Looking for help writing a MACRO to undertake the following. I have a spreadsheet with multiple tabs x 11 - these tabs have team names, for example North, South, West, East. My existing MACRO transfers all of the tabs to a Summary tab at the end. However I have found that when I do this I...

Hi, Long time user, but new to posting. My workbook is used to perform scenario modelling, and contains a number of worksheets, named 'Base', 'Adj1', Adj2', 'Adj3'........'Total', where Total is the sum of all preceding worksheets. However, to complicate matters, I want the ability to...

I have a file that I was assisted on by Fluff in the past. I am looking for a little bit of help. The macro that was created works perfectly and will split one table out into several tabs based on a specific name. What I need to do now is create an additional macro to create a completely...

is it possible to combine data from 100 tabs into one - these are all receipts from 100 customers, so each has a date invoice number payment numbers, amount on each tab i want to get all the data into one tab so i make analysis?

Hello All: I have a workbook that has a tab named "Log". The workbook also has many other tabs as well. In the "Log" worksheet, range A3:A200 contains tabs names. Range D3:D200 contains either "Yes" or "No" or "...". I would like to add VBA to hide tabs where (for example) if D3 contains...

Folks, I have inherited a report which is causing me some grief. Originally, in .xlsm format it comes in at a hefty 300mb but its only 38000kb in .xlsb. So its not a large file. there are a handful of simple pivots stemming from source data held in dynamic named ranges, and a few navigational...

Hi Friends, I’m not sure if this is possible using standard Pivots or Functions, but if it is then I know someone on here will have the solution. Basically I would like Excel to return rows of Data based on a single Criteria, but with the difficulty of being across multiple Worksheets (or...