tabs

Hello, I have 35 tabs that are updated daily. I want a summary worksheet that will combine everything that is on the 35 tabs. Info can be updated on these 35 tabs at anytime and would like the summary worksheet to reflect the changes made on any of the 35 tabs. Each tab has the exact same...

Hello all, i was kindly helped with a vba code today, which worked great, but i've come across another issue. i have a summary sheet with a list of suppliers, which all have their own tabs. i wanted the suppliers in the summary sheet to match the colour of the sheet tabs. my problem is when...

Hi, how would i go about creating worksheets for every possible combination of data. but the data is in the same row, only separated by by one blank row... there are significantly more then shown below.. x1 x2 x3 y1 y2 the tabs (new worksheet) should be created is x1-y1 x2-y1 x3-y1 x1-y2...

Hi All, I have a summary sheet with all my suppliers on it. is there a way I can colour the supplier names in the summary sheet with colour of their tabs. thanks in advance.

Is this even possible vba code :- pressing space bar to navigate sheet tabs? Selects and displays next sheet each press

I have an excel workbook with multiple tabs. I am looking to send each tab to a different email address. The individual email address will be located in the same cell on each tab. Is there a VBA code that will perform this task?

I have a master spreadsheet (Tab 1) which goes to cell EM:3500. The boss filters for specific data, copy/pastes the filtered data to another tab and then runs calculations. This easily results in 20 tabs for a specific project. The problem is keeping up with revisions to the master data. How can...

Hi everyone! I have a userform that I set up with multiple tabs. On one of these tabs, I'd like to be able to reference my userform and scroll simultaneously in my workbook. To achieve this, I know that I have to go into vbmodeless. The problem I'm running into is that one of my other tabs...

Hello Mr.Excel I have multiple set of workbooks where the file name is standard except first two letters. In each workbook I have multiple tabs where the tab names are standard across the multiple workbooks. I am looking for an macro to convert the excel tabs into separate PDF files...

Hi, I have amounts in Sheet1 ‘column D’ and Sheet2 ‘column C’, I want to copy and paste the amount in following tabs in column B and column F with the below criteria. Criteria to be match is date and plan ID (Which is in H1 in all tabs). Thank you so much in advance

Good day all. I have a spreadsheet with 80 (and growing) tabs. When this file is distributed, I would like all tabs to be protected with a password. I have VBA which does this: Dim wSheet As Worksheet Dim Pwd As String Pwd = InputBox("Enter your password to...

Hi, I hope you're doing well. I was looking if you could help me to create a macro with the below condition; 1) Start Timer (for 5 minutes) & the Stop Timer(seems to be not working, need help to make it work), 2) If the Stop Timer button is clicked, then the Start Timer button should be...

Hi I have a folder with 7 workbooks in it. All workbooks have 3 tabs in them and they are all named the same in each workbook. What im trying to do is merge all the workbooks together into one with all data from each tab. I.E all data in tab one in the 7 workbooks to be merged into tab one...

Hi, I have different tabs in a sheet , namely , A, B,C etc. Tab A has multiple rows with values in a column H ,labeled as 'John" and the same with other tabs. I now want to display total of the values from the tab A and other tabs. Eg:- A = Sum of Row H B= Sum of Row H etc. Please help

My file could have about 30 tabs in it, one for each volunteer. If a volunteer didn't work on a particular day there's no tab for him. That's always been OK but now I need to add a tab that looks at a list of volunteers and if a person doesn't already have a tab in the file I need a blank tab...

Hi All, I hope that you can help. I have 4 tabs on this sheet. 1st tab is my shipping info that I drop into the sheet and 3 of them have info I need to reference from. The problem is I keep getting 0 on half my look ups. So I tried to use =IFNA(IF(VLOOKUP(A2,'Redding...

I have a report with links to files that might not exist and to tabs that might not exist (but are in files that do exist). I'd like my report to be the same every month requardless so the same file works every month whether or not certain files or tabs are missing. How can I do something...

I have a spreadsheet that has many Tabs. I have named each of the tabs with a unique name. I would now like to insert that tab Name into each worksheet in location A1 without having to retype the name each time. TIA

Hi, Have code that hides the sheet tabs: ActiveWindow.DisplayWorkbookTabs = False Unfortunately, the User can change this via: Excel Options->Advanced, section Display. Is there anyway to prevent the user re-enabling the display of workbook tabs? In this instance Sheet.Visible =...

New to Power Bi, first report. Not sure what I did, but had two named report tabs on the bottom. Now it just says "Page 1 of 2" with no tabs. Any help with getting back the tabs would be much appreciated!