multiple sheets

trying to debug a former teammates macro (novice user myself). object is to copy a small range, formatting and all and post in the same location in multiple worksheets that match certain criteria. in this case, moving July end of month (range g6:k8) to daily breakdown worksheets (all of July...

I am building a VBA to generate a report but have never built a VBA before. User enters: Date From (B3) Date to (D3) Employee (F3) *Enters "All Employees" if wishing to include all employee data They hit the "Submit" VBA button and...the data populates beginning in A12 of the active sheet...

I want to move multiple sheets to new workbook. Currently, I am using the code posted below and it works just fine. However, its limited. Is there a way, Where I can count the sheets in the workbook first, then run the code to generate new worksheets and move only newly generated sheets to new...

Hi, I have a spreadsheet with multiple sheets within. (Sheet A, Sheet B, Sheet C etc). For each row in sheet C, I want it to search Sheets A and B for cells containing parts of text, then show the text from that cell in the corresponding cell. The formula I have currently is...

I want to run a script when leaving a worksheet. When I put the following code the code runs in the current sheet and not in the targeted sheets. What's wrong...? Sub Workbook_Deactivate() Dim ws As Worksheet Dim x As Long Application.ScreenUpdating = False...

Hello, I currently have a macro set up that triggers an Input Box to input a range of dates. Once entered, it scans through the reference sheet and copies and pastes a specified range of cells from any rows containing a date within the input range. I've been trying to edit this macro to...

Using Excel 2007 in Windows 10, but had the same problem in Vista. Have a workbook with about 50 sheets, half are data sheets, half are charts based on the data. To print only the charts, I hide all data sheets, right-click on a chart sheet and select all sheets. In print preview, I see 68...

I am attempting to create an Excel file that will allow my supervisors to view the last date an employee entered activities into their excel file. A workbook is set up for each employee with column K holding employee numbers and column a holding the dates. There is a different sheet for each...

I am trying to set up a workbook for a daily log sheet, one sheet for every day of the month. Into a cell, I want to enter a value, which would be a meter reading, then have the value from the same cell in the previous sheet subtracted from it and entered in an adjacent cell. This gives me the...

This has been posted a few times before but the answer has never been definitive nor has it been dynamic to work in a multitude of situations. Sheets: DataSheetA DatasheetB DataSheetC DataSheetD Starting Point: $C$10:$C$999 =INDEX(DataSheetA:DataSheetD:$E$10:$E$999, MATCH($C10...

I have one workbook with a summary sheet, an 5 to 7 input sheets (asset register) that I want to be able to select a dropdown on the summary sheet for say the branch and the workbook automatically filters all the input sheets by branch entries (all branches are included per asset category per...

I'm happy with the way the code works (thanks Skywriter), I have worked out how to append the filtered data to an existing sheet if it already exists, but I just cant seem to do it without the heading row. I have followed the code in the multiple posts on the subject but keep getting a...

Hi! I've pieced together some VBA from the internet to adjust the Y axis based on the calculated results of specific cells. The VBA works wonderfully for the chart on the first tab. The problem is, when I copy and paste the VBA to the next sheet, adjust the cell references and the chart name...

Hi there, I am currently working to have a spreadsheet that has a macro that can search for a set cell value in multiple other sheets, then jump to that found cell.# For example, cell $G$15. A user can enter a six digit code in here, then click a macro button. The macro will search for the...

Good Afternoon, I have searched a few things before creating this post so I apologize in advance if this was already done. The ones I have seen perform somewhat of what I'm trying to do, but not to the exact and my VBA/Formatting/Pivot knowledge is very very minimal. What I'm trying to do is...

I have been tasked with creating a large workbook to track productivity for a department across all of the weekday for the year. It must also include a sheet for the year-to-date average production for each member of the department. The way this was done last year by using a new worksheet...

Hi, I am trying to take string data from multiple sheets that is listed in the same row each time, and summarise it in a column (or row), while removing any gaps. There may be a quite obvious fix, but I have found no solution. So I have data that looks like this: Sheet 1 <tbody> A B C D E...

I have the following problem: I would like to copy a cell in sheet one, switch to sheet two and search for the value that was copied; once found, then move over 8 columns and copy the value of that cell, switch back to sheet one, move over 8 columns and paste that value. And do this for as many...

Hello! I have the following problem: I have one workbook with 36 sheets. All the sheets are alike: same structure, same column names. The data varies. On each sheet I would like to look for each one of the Column 1 values (Member_Name) on each one of the previous sheets. If the name is there...

Hello I need help!.. I need a formula that looks for the data related to a specific cell across multiple worksheets and returns the the cell name along with the sum of all the its data. For example the part number 00045 has a column listing if was either deleted or added and another column...