tab

I have a spreadsheet with 2 separate sheets set up as follows: Assignment: <tbody> Department Bucket Shift State Product Home Health Nights Toys Nights Sporting Goods Nights Grocery Days Toys Days Furniture Days Pets Days </tbody> Summary: <tbody>...

Hi, how can I hide the 'right click' options on a Worksheet Tab (not the Worksheet Cells) pls... I have a Worksheet that I lock with VBA (password) and I dont want users to be able to unlock hte Sheet through the 'right click' option, eg: Insert / Delete / Rename, etc

Hi, is it possible to use a macro to insert 10 empty rows in row 1 of a workbook and do this for every tab in the workbook? Then I would like to copy a table and I insert this into the 10 blank rows created? I have 100 tabs on the workbook so want to avoid doing things manually. Thanks.

Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...

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

I would like a formula to grab new products and add them to a list. For example, I have two tabs. In tab A, I keep track of how much we sell/buy by product (so we bought 10 apples and 15 oranges and sold 10 oranges) and in tab B is a sumif formula to add up the sum so we know how much of each...

Hi Everyone, I have data I want to split up into clients names. In range K5:"Last column" & 5 I have a list of clients names I want to create a tab for each client and add there data to that page but I have a umber of problems please help if you can? So for each name I want to create a tab...

I have an excel document that details the projects we're working on and who the PM is. plus a lot more detail about that project this is one a tab called Team POAP. I want to create a summary overview on a different tab (called Timer Tracker) that shows the PM down column A and then in each...

Hi, I have a list in column H, from H5 to H999. I have the same list on another tab in column D. If the user changes anything in H5:H999, I want the cell to turn red. How can I conditionally format this so H5 looks at D5 from the second tab, H6 looks at D6, H7 looks at D7, and so on. All of...

Hi all, I am trying to use a tab name as part of a VLOOKUP formula however what I have so far returns #N/A VLOOKUP Formula =VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE) And in cell U5 I have the following: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) In this instance this...

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

I am working with two workbooks. In the first workbook, I have a worksheet that lists 100 ip addresses. I have another workbook that has 100 tabs. Each tab matches one of the ip addresses that are on the first workbook. Also, each tab in the second workbook has anywhere from 10 to 30 rows of...

Hello, I have all my Data on a tab called "Queue Data". In Column A is the Queue Name. Column B has dates. This tab will have daily data put into it so the names of each queue will be listed multiple times and will look like the below example: Name Date EUC 10/20/19 SBKC 10/20/19...

I am in need of a vba module that would allow me to do the following: I currently have a workbook which is Titled "Aspen DPR 10-19". The "10-19" changes based off of current month-year. This Daily Production Report has a tab titled "Monthly Report" and also has a tab for each day of the month...

Hello everybody. I'm a newbie about automating external application via sendkeys method. Now, I can get in the external application, I can write (for example "5"), but I cannot shift the focus two fields on the right (as I manually do without problem). I mean: nothing happens. Maybe somebody...

Hello, I have a workbook with over 60 tabs, example of their names: 111100 111100A 111100Detail 111100B 213100 213100Detail 213100A 131460 131460Detail 312504 312504Detail 312504Ele 312504Wat 312504Gas so they all start with a 6-digit code and they all have a code+Detail tab...

Hello, I am fairly novice to using excel, and have searched for my answer but am running low on time to find an answer, so figured I would just post to see if I can get a speedier answer. Below is an explanation of what I am trying to do. I have two tabs in a workbook with some of the same...

Hi everyone, I used the second VBA code option on the following site to make sheet/tab names equal a cell value within their respective sheets: https://excel.tips.net/T002145_Dynamic_Worksheet_Tab_Names.html The problem is, the names do not update automatically (as is claimed on the paged)...

I have a spreadsheet I need to add tax ids to but tax ids are on the second tab. I want to match it with vendor number. Would vlookup be appropriate and how would it work? Say the vendor numbers are in column A on both tabs but the tax Id is on tab 2 in column b.

Hi, I wonder if anyone could help as I have been wracking my brains. I have set up a fomula to lookup against data on a different tab on the SAME workbook. Example below - this lookups the tab number noted on cell D21 of the current sheet, finds the 2nd column (column B) against the lookup...