worksheets

Hi, I would like to loop thru all items in a drop down on Sheet1 and copy/paste results to different worksheets in workbook Similar to how Show Report Filter Pages in a Pivot table works. Thanks in advance.

I tried following a previous post but the instructions did not work. I have a workbook with 3 worksheets. Worksheet #1 has a list of Document #'s to choose from when logging in a new document. At present, we are cutting and pasting the next Document # in sequence into 1 of the 3 worksheets to...

Can anyone help me please? I have a workbook with multiple worksheets. Worksheet#1 is the one that the user will beactively using. It has hyperlink to other worksheets within the sameworkbook. These other worksheets areinformation only. When I hide the otherworksheets, the hyperlinks stop...

I am trying to use Conditional Formatting to highlight duplicates across 3 worksheets within the same workbook. Is there a way to EASILY do this? Please advise. Thank you!

Hi All, I have lots of workbooks in one folder. Each workbook contains a worksheet called 'Visit Report'. My objective is to copy all visit report worksheets from every workbook within a folder to a master worksheet. There is alot of this online, but I couldn't get any of the VBA to work for...

I want put NFL grid schedule into teams worksheets. look at worksheet Teams by division. I want a vba code on the button is on worksheet that is called Put schedule into teams worksheet. GET PICTURES HERE IS ZIP https://1drv.ms/u/s!AnJwxxiz0Ezpg8c5giTqpAFxNZfW7g GET FILE HERE...

I just got done creating a couple of password protected files (.xlsm). Works fine when using Excel, but I can open them with LibreCalc and all the worksheets can be unlocked/unhidden without any password protection. Any solutions for this?

Hello everyone, I'm trying to convert all worksheets of the excel file into individual PDF and automatically attach to individual email (outlook) message each one of them. So far I was able to rename each worksheet (as per a certain cell) and save as individual PDF, but I still can't figure...

Hey Excel Gurus, I have a large data with multiple worksheets. Please my requirement this time is for a vba code that performs trimming on the existing data present in all worksheets of my workbook. For example if text is (without the quotation marks): " abc def " the code runs and check for...

Hi, I have a excel log book for booking resources with multiple worksheets for each month of the year. Each worksheet has the same templates (same headers). Like Column A-D is for Book A, E-H is for Book B...etc and Column A, E will record the user name, Column B, F will record the contact...

I have a Workbook with multiple worksheets. Some worksheets contain formulas, some worksheets are protected but imported worksheets are not protected. The active workbook was named "Analyze.xlsm" I want in the same folder the workbook 'Analyze.xlsm' save as 'Analyze-Month-Year-Date-Time.xlsx'...

I have a worksheet with about 60,000 rows and 20 columns. I need to make about 20 copies of the main worksheet and then filter slightly differently on each of the other worksheets. This is a daily process so I'd like to automate it more. I started off pretty basic with just a formula...

I was wondering if anyone could direct me to the proper code for this, as this is really tedious. Basically, I have 7 worksheets in a workbook I am updating. Once all the calculations are made, I then need to copy certain ranges of these worksheets to files/workbooks (as values) that go by the...

Hi, I've been tasked with creating a master worksheet for locker allocation across the floor. In that worksheet I need the locker number and name of the employee. Each team has it's own worksheet/tab. All the worksheets use the same template and the locker numbers are unique across the...

I have a client who is using Excel Version 16.24 (Office 365 Subscription) on a new MacBook Pro. The workbook has 8 worksheets. Two of them have all the columns to the right of column "H" deleted. When they view either of those two worksheets, it shows the columns A through H, but then to the...

Hello all, I am looking to automate a repetitive process, i have tried multiple times to get something to work with no success. Problem: I would like to automate the process of copying any rows from multiple worksheets that contain the word "ESCALATED" in a column into a new Worksheet named...

Guys, I have 5 worksheets all with tables of data. The worksheets and table names are as follows: worksheet name = BA1 and the table name is tab1 worksheet name = BA2 and the table name is tab2 worksheet name = BA3 and the table name is tab3 worksheet name = BA4 and the table name is...

Good morning. I'm new using Macros and have no idea about programming, if anyone could please help me with this I will appreciate it: 1. I receive workbooks from a customer disputing some charges, sometimes the workbooks came with just one sheet, sometimes they came with 20 sheets but they...

Hi all, I'm trying to format my tab colors based on cell value in column I. Example: "At Risk" - Red Tab "In Progress" - Green Tab "Not Started" - Yellow Tab I need it to apply to all worksheets, range for all worksheets is I9:I30 All the macros I have tried don't seem to help me. Please...

Hi, Can you please help me regarding the following excel problem. I have more than one workbooks with multiple worksheets. They all have data. I need to get the sum of data from each workbook / worksheets with multiple conditions to another master workbook. For example, the master workbook...