1. J

    Editing VBA to separate tabs and save them

    Hello guys, I've been on the forums but finally signed up so thank you in advance. Below I have a macro that allows me to create separate tabs based on an unique identifier found on a "master sheet." For example, I can create 5 tabs based on 5 different sales people for providing sales...
  2. H

    How to filter Excel sheets by color

    Hi Guys So I opened an Excel file and created a sheet1 solely for my Facebook groups, sheet2 for Facebook Friends, sheets3 for Facebook Pages that I'm a member in. In the Sheet4, I want to make it only for my Instagram account followers, Sheets5 for Instagram followings...etc and so on. The same...
  3. K

    Renaming Worksheet VBA to insert in Longer VBA

    I am trying to split out a workbook with about 100 tabs into separate excel files, so I can PowerQuery them. I have it to the point where it splits out my files and renames them and puts them all in a folder, BUT I would LOVE if I could figure out how to also have the VBA rename the worksheet...
  4. G

    How to Hide/Show Tabs off list in workbook

    Hi All, Need alittle help. Would like to create a macro that will either Show(S) or Hide(H) workbook tabs based on a list in a separate tab. So in a nut shell if Column B is "S" Show Tab in Column A. If Column B is "H" then Hide Tab in Column A. Can any of you wise guru's help me out? Thanks in...
  5. myactiondesign

    VBA Duplicating a sheet then renaming tab, changing tab colour, and adding title based on list of names

    Hey everyone, I'm looking to create a fresh workbook based off a template for OKR goal tracking every quarter. I have a list of team names and the below code already works to duplicate the template and create new tabs, change the tab names and change the title of the template to the team name...
  6. A

    excel export to txt file without tabs

    hi Folks, I'm trying to make a post for a Fanuc milling machine. I've got most of it working now, except for one thing. The problem are the tabs behind the lines when exported to .TAP, the machine cant read these tabs. Is there an option to add to the code below so it leaves out these tabs? (I...
  7. L

    Password Protect Tabs (or only able to view a certain tab)

    Hello all! New user to Excel (previously Google Sheets). First of all, I have tried to check other posts that are similar and google, but don't think I have found exactly what I am looking for as each seem different. I currently have a spreadsheet to review Pay Rises, Overtime etc. I have...
  8. W

    How to create a input sheet that then allocates to different training courses tabs corresponding to the specific course?

    Hi There, I want to make a excel sheet that can do the following : I want our sales team to enter all the bookings information on sheet and then create a tab for every course, as they enter the bookings in the input sheet it should allocate the bookings to the specific course tab for example...
  9. M

    Ribbon changing appearance when pinned/unpinned

    Hi All, this is driving me crazy... When I have my ribbons unpinned (aka show tabs) they appear like this - as they have always been, but as long as i move the cursor away they disappear Although, if I pin them (aka activate the show tabs and commands option) they are shown as below, occupying...
  10. F

    Share only specific Tab from Workspace

    Can you share specific tab's from a workspace without sharing the entire workspace?
  11. D

    Classification pop up issue when saving file

    Hello all, I would like to get some help in how to automatically assign the classification as internal document. At my company we use some classification tool in excel called Secure Islands Classification, and whenever create new file it pop ups asking to set the classification, usually...
  12. W

    Help! Formulas Disappearing After Every Save

    Hello, I have a problem that I can't find any information on online. I hope someone here can help me. I work with excel workbooks that have several spreadsheets (tabs). On some of the workbooks (no rhyme or reason I can find), any formula that is pulling data from another spreadsheet within...
  13. J

    macro is skipping tabs

    good morning, Newbie here...i have a macro for auto generating tabs into PDFs and save them. the issue i'm having is that it is randomly skipping over some of the tabs. anyone have an idea how to fix this? I checked the ones that get skipped to see if cell "A5" is the problem but it is not...
  14. A

    Workbook_SheetChange event

    I need pivot tables to refresh automatically once a user enters new source data. I have my workbook set up on monthly tabs and the users can enter data below row 12 on each of these tabs. I have set up the workbook with dashboard/display tabs at the front and the monthly data sheets at the...
  15. VBA learner ITG

    V lookup Across Multiple Tabs and Return Multiple values if found on a tab

    hi all, Need your guidance if possible on how to amend the below array formula to do a lookup all tabs listed below? =IFERROR(INDEX('4.RANGING CONVENIENCE'!$B:$B,SMALL(IF(B$1='4.RANGING CONVENIENCE'!$A:$A,ROW('4.RANGING CONVENIENCE'!$A:$A)- MIN(ROW('4.RANGING CONVENIENCE'!$A:$A))+1,"")...
  16. J

    Summarize 3 Tabs into 1

    Hi all I have a customer order form spreadsheet with 3 existing tabs, each tab has a different product range and there are rows for each different product with columns for price, description, SKU and quantity ordered. I need some help please with what formula to use so that on a new fourth tab...
  17. L

    Automated Stock Sheet

    Hi, I’m trying to find a solution to automate a stock sheet. I have a register of various sizes based on diameter and length on one tab. On other tabs I’m trying to look at the first tab and automatically add new items or down date quantities you can see on the used / create tab, it has two...
  18. C

    Vlookup Indirect and Match function error

    Hi all, I would like the formula to find the pricing across multiple tabs and the problem is the pricing column. The pricing column is situated on a different column letter on each tab. Would it be possible to replace the 1 from the formula to a match function? like the formula below...
  19. N

    Formula to identify text in one cell and group in in a new tab?

    BLUF - I looked through the threads best I could and did not see this answer, so I am very sorry if this scenario has already been answered. What I have is a workbook with 6 tabs (one "data" tab and 5 other tabs representing the days of the week). The data tab contains a list of 22 students...
  20. D

    Excel tab menu options some greyed out?

    Hi I have a work book with many tabs, Excell 2019 the book or tabs sheets are not protected. The menu options (all except 3 of) in the tab menus are greyed out. Can anyone assist as to why this is? Note it is only this one workbook as with other workbooks it does not apply. Regards

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back