tab

Good Evening, I have a Case code question. In having: Case "Tab Name" Now the represents just that, the name at the bottom of the tab of which is the actual name of the worksheet. Is there anyway to specify this in a generic fashion? For example...

My DATA tab lists Name (Column A), Date (Column K), and about 10 other columns of info. Row 1 is a header row. In my Report tab, I use Data Validation to display a dropdown for the Name and another for the Date - both in Row 1. Row 2 is blank, Row 3 is the same header row as in the DATA tab...

I am trying to find a code that will work to change sheet tab color to red if a cell in a different sheet has a date that is less than today's date in it. Ex. Column H in Sheet1 has registration dates in it, Sheets2-30 have vehicle information in them. Sheet2 tab turns red if the date in H1 of...

Hey guys I am having a roadblock in creating a pivot to analyse the data. I have a report in the "Details" tab and calculations are done within the tab. For example, I have a total cost for a line item by month (from column U to column CZ) and the cost is then allocated to different...

I am trying to write a formula that look at the header on the main tab for example AC6 contains a date 11/01/2020. I want it to look at the date in this tab, then go to tab titled Care Design and look the dates in column C and when it finds a match bring back the value in column I. The problem...

Hi All, I am attempting to create an archiving system for work and having some trouble finding a way to do a certain thing because I'm not sure how to word it for the searches... So, we have an archiving system, which is a 9 x 9 box for samples (81 samples); on the worksheet so far i have a...

Hi All, I am looking for VBA code where following steps areperformed: Open website https://www.abs.gov.au/Price-Indexes-and-Inflation Click on link “Consumer Price Index” on that page. Click on “Download” tab on that page. Open .Xls file from that page (do not save that file). Copy...

Ok, so one of our executives often works on excel files straight from email - in other words, he opens an excel file straight from an email and DOES NOT save the file before making changes. He will have 20 excel workbooks open all in READ ONLY status. Well, he worked on a READ ONLY file for...

Hi, I am executing a coding using sendkeys method. I wouldnt like to show the pages in the internet that I am using until the code delivers the resultant. The code below opens the google translator and write something, then it plays the audio from google translator audio play. How to hide the...

First tab: 9.17.19 Second tab: Next Download I'm using index/match to pull whatever is in $O$2:$U$300 in the first tab based on if $A2 matches $A:$A in the first tab. So, in cell O2 of the second tab, IFERROR((INDEX('9.17.19'!O:O,MATCH($A2,'9.17.19'!$A:$A,0)))&"","") I use a similar formula for...

Hello, I have two workbooks, 2018 and 2019. Both have 100+ tabs with different names. 2018 has data in various cells throughout each tab. 2019 has the same number of tabs with the same titles as 2018, but is completely blank otherwise. I would like to copy multiple cells from 2018 (A4, B18...

So I am using filters to hide data from users. Depending on a login password. I un-filter or filter certain rows and then use filter refresh. However I guess anyone can link to tab on another sheet or file and then just copy up or down and see the filtered rows. Is there a way to stop this?

Hi, I have a form on a tab in the spreadsheet that links to data on the first tab via VBA coding. I have updated the names of each column in the name manager part of formulas but 2 sections of the form aren't pulling the data through from the sheet like the rest of the form instead of populating...

Hi all, My workplace has recently moved across to O365 and use Teams. Within our Sharepoint file structure/Teams, we have a workbook that is manually updated each week. In the workbook, I have a sheet, called 'Dashboard'. On it there are a series of view only charts. Does anyone know how I can...

I am wrecking my brain over what formula to use to summarize data (into a chart) using the data tab. Below on the Summary tab I would like to know how many Fruit, total AND individual, do I want and how many I've purchased for each date. As time passes, I will change the date in Row 2 and I...

Trying to write a macro that will add 2 new columns (A & B) to each sheet in the workbook, adding header names & color coding, but need it to stop when it reaches the tab named "Master" Below is the code I have so far, but keep getting a compile error in the 'Start loop' section Sub...

Good morning All, I am trying to write a VBA to search for either a PO# or Document # and from that return Additional information. I have a workbook with 2 tabs that this would work with 1st Tab is "Transactions" -- PO # would be -Column "X", Document # is column "V" 2nd Tab is...

hey everyone, i need some help. I have finalized my workbook, each tab has one page per sheet in the workbook, i want to send this to my team however I want them to view these sheets as page layout view. my problem is i only want the active sheet in each tab and i can't get rid of any...

I am hoping one of you VBA gurus can help me with a script to separate rows of data into multiple sheets in a workbook. The data is in 5 columns over 1000s of rows for many customers. I cannot export the data any other way. Column A has: 0 (zero) - Header row to show the change from one...

S1 is my macro template. S2 is the actual report which gets a new tab each month. Ex. T1-Jan T2-Feb- etc- to current month. Sometimes there are changes to S2. So, I want a system to cross check if anything has changed. Exaple. S1 n S2 look identical unless a new loan type was added. So - I...