worksheets

I'm attempting to link worksheets using ='worksheetname'$A$1. I'm getting that reference in the cell I'm linking and not the actual value in the cell I'm attempting to link. Thoughts please.

Afternoon all First and foremost, thank you for your help in advance. Greatly appreciate it. I am building a workbook whereby I have a code in 4 worksheets that hides columns based on a value found in row 5. The code in each of these worksheets is within their own sub and is as follows: Sub...

I have about 90 worksheets in my workbook. About 75 contain sensitive financial information that I don't want available when someone is sent the file. Is there a way to "group" the 75 sensitive worksheets so that with one click of a Macro button, all 75 worksheets are hidden with a password...

Hello I have two spreadsheets in the same workbook, I need to pull information from each into a third worksheet. The worksheets are labeled ASV, IAR, Combined. The two worksheets have alot of columns (not necessarily the same columns). The number of rows vary between the two Is it possible to...

Hello everyone, I'm trying whithout success to loop through worksheets hope you can help me I have a workbook with 40 worksheets of my employes The 40 worksheets of employes have those names 10 worksheets are for the first group : 22-01, 22-02 ... 22-10 10 worksheets are for the...

My project is to recreate MS Money in Excel - thanks to my son’s advice and the inspiration from the helpful members of various Excel Forums. Now it’s testing, creating and revising display formats and testing, testing again. Could any member help me to find a solution and to understand why...

I've been searching the net, but am having a hard time finding an answer. I'd like to understand this before continuing my work. I read that the difference between Sheets(" and WorkSheets(" is that in older versions of excel, there are different types of sheets, and that for today's standards...

Hi, I have a total worksheet I have 4 worksheets, Week 1, Week 2, Week 3 and Week 4. All set in the same format To get the totals I need from each sheet, I have been using Sumifs. To add up the totals from the different sheets, is there a alternative to...

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 multiple worksheets. In cell "M3" they all have the following formula adding up columns within it: =IF(R3,R3+S3+T3," ") On the Summary page I have this formula trying to add up all the worksheets but it's returning a VALUE. I want it to return a sum for all the worksheets in that cell...

Hallo Cananyone help me? I have aworkbook with multiple worksheets One worksheetcalled “Search” is where data need to be past to. Allother worksheets have filter buttons that if in use needs resetting, show alldata, before start searching for data. Worksheet“Search” needs to be deleted of all...

Hi, hoping someone can assist with using VBA to export worksheets. I have a workbook which has 30 reports (on separate worksheets) plus some other worksheets. One of the others worksheets is called "Export" which allows the user to select which reports to extracts using Range A1:A30. This range...

I have the below code that currently shows all worksheeets in the workbook. I would like to modify it to only show the hidden worksheets. Private Sub ComboBox1_Change() 'Updateby Extendoffice If ComboBox1.ListIndex > -1 Then Sheets(ComboBox1.Text).Select End Sub Private Sub...

Hi all, This has been quite a wonderful forum and great place to learn. I have the below problem which I require some advice. 1. I am trying to consolidate the sales of a few items from 3 different sources (3 different worksheets) 2. These 3 different worksheets name all these items...

Hi there, I am very new to this but I would like to seek your views on how to go about doing this. What happened is I have 5 different worksheets which call the same thing by different names. For example, 1. Worksheet1: apple 2. Worksheet2: applie 3. Worksheet3: green apple 4. Worksheet4: red...

Hi everyone, Can we sort the excel worksheets based on the dates. like example, One of my workbook contains more than 50 worksheets,and each worksheets would be named like "31-01-1990_GHUJJIUK","29-05-2019_kdsajasjads" and so on . Where in beginning of each worksheets date would be provided...

This problem has been driving me nuts, because it should be simple, but it's not working. I have the following formula in a table called tblCurrentHoldings on the sheet CurrentHoldings (see screenshot: https://1drv.ms/u/s!ArArDJ7WmD62grkdhF-Y-3Epey_0_g?e=vkjFxq)...

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

I have this working if both columns are on the same worksheet, but I need it to work with 2 different worksheets in the same workbook. Help: Sub UniqueLooks() Dim rngCell As Range Dim r1 As Range Dim r2 As Range Set r1 = Worksheets("Res").Range("A1"...

I have a number of workbooks with different passwords. Sometimes worksheets within a workbook. I am not allowed to change them. So what I would like to do is loop thru all worksheets an try all the PW's But I cannot get this to work. Sub Un_Protect_All() awsn = ActiveSheet.Name For Each...