multiple workksheets

Hello, I am looking to create two separate buttons using VBA and have not been able to successfully write a working code for either. I am trying to have both these buttons edit every Excel file in the same folder as the excel workbook containing the button and every sheet within each Excel...

Hi All, I'm attempting to apply the below code to 26 out of the total 35 sheets. I can't seem to figure it out. Currently the macros is setup to apply to all sheets but I need to either edit it to exclude the eight tabs that it will not apply to, or edit it to apply to the 26 sheets themselves...

Good morning All. First time poster, but have used the forum and associated code more time then I care to admit! Unfortunately, I have not been able to find/modify code to achieve what I want to do. I have workbook that has a number of sheets (for this example, they are named Item1 to Item8). I...

Hi All is it possible to do a dynamic validation list using data from multiple sheets. I have a front page and 4 identical sheets, just with different sheets names. I need to be able to have the list of all names in B3:B75 from each sheet in 1 list, also needs to ignore any blanks. Working on...

I could use some help with this formula...

-Excel 2013 -Windows 7 Professional I would like my scroll button to hide the same rows in specific Worksheets. I'm new to VBA so I used the Record Macro trick, however the constant switching the screen does causes the application to freeze. I wrote the code to the point where it hides the...

Hello, This is my first post on this forum. I have been tasked with compiling data from the same column in many sheets (290). -The sheets are all in the same workbook and have an incremental name (SO17000-SO17290). -The column contains data that looks like this: 6129/110 I need to compile...

Hell, I have a folder at the following link where we keep monthly summary reports of all orders placed - each month a new report for that month's orders is added. Is it possible to create an access database and link it to ALL EXCEL FILES within A FOLDER. As new reports are added to this...

I want to be able to insert a picture into each worksheet of a workbook, but I don't want the picture in a cell, I want it in a location relative to the Print_area (as the number of columns changes in each ws) The picture can be the same size in each ws, but just needs to be located in the top...

Hello, I am attempting to get my code to loop through all worksheets that begin with "Labor BOE", find all numbers in column A (beginning in row 2), insert that many rows below the cell with the number, and then drag the formulas down. For example, if cell A10 = 3, then I need 3 rows to be...

Hello, I am receiving a "Run-time error '13': Type mismatch" when I adjusted my code to loop through all worksheets beginning with "Labor BOE" instead of just the specific worksheet I was working on. Does anyone have any thoughts on why this is occurring and how to fix it? The goal of the code...

Hello, I am teaching myself VBA (with a lot of help from MrExcel) and I am running into an issue when I attempt to expand my macro to more than one worksheet. I have successfully tested the code below, which searches column A - and when it finds a number, in column A, it inserts that many rows...

Sorry guys but I don't even know how to search forums for this specific request. Here goes.... Purpose: Create an organic sheet to track who is assigned what equipment spread across multiple cells. This needs to function regardless of which filtered column is re-sorted at any given time...

Hi I need help in writing a macro to copy information from multiple worksheets into one master worksheet, within the same workbook. I have multiple worksheets which are my sales invoices, and a master sheet where I would like to copy all the line items from my invoices, including the invoice...

The workbook that I am starting in is called "Rachael" The workbook that I am trying to copy into is called "Jessica" This workbook has two tabs that I need to paste into “Summary” and “Summary Fall” The range that I need to copy the information into is: X 8:61 - "Summary"...

Can someone let me know if I am taking the best approach? I have a workbook with 24 worksheets, all requiring unique bottom margins and scale settings. I need the users to print and create pdf versions of the worksheets they use with a consistent appearance so I plan to apply a Private Sub for...

I would like my Macro to go into all works sheets and look at the last row of I matching todays date and if this value is under 20% then to paste the name of that worksheet back into the master worksheet allowing a quick overview of under performing data. I think I have got the selection...

Hi, I have 2 files. One file is the source of data and the other file is for extraction of the data and analysis. In the first file, I have many worksheets, but I would like to consolidate the data from worksheets, which contains "production" in the worksheet name. The destination of the...