multiple worksheets

Hello, So, I know how to link one worksheet to a main worksheet so that when I type a new row of info in the second worksheet, the first one changes, too. How can I get an existing workbook to do this when there are multiple worksheets? We want the main worksheet to update automatically with a...

Hi, I have a rather large company salary review tool cols A - BQ which I have built and needs to be split by Reviewer (col L). The document has over 4869 lines of data but I want to keep all other functionality ie macro buttons and so on. Basically it should be a copy worksheet, and then cut by...

Hi Everyone, I am looking to select a column with numerous 4 digit numbers in it and have any of those numbers in the column be automatically highlighted or font color changed in multiple worksheets. Example: worksheet 1 4 Digits need to found in all other worksheets 5496 4526 9600 1234...

Hello, Ive used countif and sumif statments alot but not utilizng multiple sheets usually the data and formula are all on the same sheet but i Have a worbook that has a years worth of data on it and each month has its own tab. I am creating a summary page at the front and I know i can just...

Afternoon all, I have a workbook which has 9 sheets on it. They all have the same amount of columns used A-AI with the same 'headings'. We use it for keeping track of our training. Depending on where someone is in the training programme decides which of these 9 sheets they are on. What I am...

Good Morning Folks!:) I am trying to converts several worksheets into a .pdf document and have spent a few hours surfing and have come up with this so far: Sub PDFPrintNSave() Application.ScreenUpdating = False 'Sheets(Array("Sheet 1", "Sheet 2")).Sheet1 , , 1...

Is there a way to display multiple cells in a separate worksheet that are a part of multiple worksheets? Please see below. Worksheet 1 has list of email addresses in column A Worksheet 2 has list of email addresses in column A How to have Worksheet 3 display email addresses in column A that...

Hello, I am using the following macro to find the text "No" in column G of my worksheet (Titled "IT") and then copy the corresonding row to a sheet titled "Action Plan". I am wondering how can I amend this code so that it will search multiple sheets. All the sheets have the same format as the...

Using Microsoft excel 2010 - I have 5 worksheets within one file. I am able to combined and print all worksheets into one pdf, however, I'd like to the option to include or exclude any of these 5 worksheets based upon a cell reference for each. If cell is "Yes" for sheet1 then include that...

Morning all, I have created a code that allows me to remove rows based on a certain criteria. My limited VBA skills are now evident, as i need to extend this code across the entire workbook but have come a cropper! The code is as follows: Sub Delete_Rows() Dim rng As Range, cell As Range...

I am working with a workbook with three main sheets in it: 1. Summary sheet 2. Raw data sheet 3. Area list The main purpose of this workbook is to create a list of customer contracts that can be tracked and edited by the contract auditors. On the Area list all the areas the specific auditor is...

Hi, I'm using Excel 2010. So, I have 1 worksheet that is broken up horizontally by "activities," and there are 10 of these activities. Below the title of each activity is a dropdown list to select topics that were discussed during that activity. It look something like this: <tbody> Activity...

Hello all I am new to this forum and have found all of my answers on here thus far, this forum is fantastic. However I am seeking some more info, so here it goes. I have a workbook with multiple worksheets (about 80) all with the same format. I enter data on a new worksheet and name the tab the...

Being new to the VBA band wagon, i'm having some issues troubleshooting the code below. It is supposed to be able to choose multiple excel files in a folder and protect all of the worksheets within them as well as each workbook. The protect of the workbook does not have a password, it is simply...

I have 2 Worksheets in an Excel 2010 Workbook - Sheet1 Column1: contains the word "dog" Column2: contains the word "bark" Sheet2 Column1: contains the sentence "I like dogs a lot." Column2: is blank What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present...

Hi, I was hoping to create a pivot table from multiple worksheets that consist of multiple tabs. I am finding that I have too many elements within my data source to do this. Is there a solution other than making the world's largest master worksheet? Please advise. My elements are: Year...

I saw this post and I'm trying to determine how to replicate it for mutliple sheets. I have a sheet called "Discharge" which has clients who left the program in the past quarter. I want to remove anyone with an ID in the Discharge sheet in sheets Services (1) - (4). ID #'s are in column A for...

Hi, I have a large pivot which I have used Show Report Filter Pages on to create a new workbook with multiple sheets with pivots (Approx 80 worksheets). I understand that it is not possible to group sheets and conditionally format them so I am trying to use VBA to do this for me. I would like...

Hello, and thanks for providing this forum. I use Excel 2010. I do not understand VBA. I am looking at the Excel Aggregate command video on You Tube at Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE - YouTube (Excel Trick 797). I want to gather...

I am looking to create a macro that takes data that is on a master spreadsheet within the workbook and split sit out into three different worksheets. Each worksheet would be based on specific criteria that the item on the master must meet. The tricky part I am finding is that the data on the...