multiple sheets in excel

Hello, I'm having some issues with Conditional Formatting a column in one sheet based on a column in another sheet. The Conditional Formatting only works if both Sheets have all of the same lookup values. If the value doesn't exist in Sheet 2 for example, the value in Sheet 1 will return TRUE...

Hello Excel Experts, I have a potentially novel request: I have 22 sheets with the exact same formatting/cell positions. I would like to grab values from all sheets that meet criteria. If Column C contains "Yes" on any sheet, I would like the sheet name (contained in cell A1), the Building...

I have multiple tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my "critical numbers spread-sheet" with wanted numbers per application identified in each tab but columns and rows are inconsistent. I have...

Hi, I am trying to achieve data transfer from one sheet to other by using Index/Match combo. I have attached a sheet with sample data. Essentially, i have list of unique IDs on both tabs with corresponding data. On Sheet 2, I need to port data from Sheet 1 for same ID with matching columns...

I have 28 tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my spread-sheet with varying data (columns and rows are inconsistent) in each tab. I need a summary tab with count of each column per tab(only...

Hello, I'm not sure if this is possible and I have limited knowledge of macros. Here is what I want to achieve: I have a Summary Sheet with a list of names and ID numbers vertically and each month of the year horizontally as columns - e.g Jul 2019, Aug 2019, and so on. I will then have a tab...

I have 7 sheets. On each sheet the user can select an item from a list and write a description in the column next to it. The item can be selected multiple times on the same sheet with a different description written in the column next to it. I need a summary page where it lists the entered...

I have workbook containing above 40 worksheets. I want to save only 30 worksheets as excel in separate workbook. Please any body can help !!! Dim wb As WorkbookDim ws As Workbook Dim DateFrom As String, DateTo As String, UserName As String Dim MySheetName() As String Dim i As Integer DateFrom...

I have a need to delete leading characters (5) from the same column (D) across multiple worksheets. I can get it to work on a single spreadsheet using the following code: Sub RemoveCORP() Range("A1").Value.Activate For Each Cell In Range("D2", Range("D1000").End(xlUp)) If Not IsEmpty(Cell)...

Hi, I am totally new to VBA scripting. Here is what I want to achieve - I have an excel file wbA with worksheets ws1,ws2,ws3. I want to write a VBA macro that creates an excel file wbB in a given path and copies all 3 work sheets into wbB (wbB will also have ws1, ws2 and ws3 - same names as...

<tbody> <tbody> Order (A) Task (B) Status (C) Designated to (D) Completion Order (E) 1 x.a Pending 2 x.b completed John 1 </tbody> <tbody> 3 x.c completed John 2 </tbody> </tbody> Hello geniuses, I'm working with an excel workbook with multiple tabs. How would I...

Hi, I haven't written/recorded a macro in a very very long time and am struggling to try and do something simple. I need to search all worksheets of a file (containing around 100 tabs) for cells which contain the text "_web.pdf". There is also other text in the cells. Then for all cells which...

Hello, I have read numerous posts over this situation, but I have been unsuccessful in solving my dilemma. I want to create an Index (Match) (Match) formula over a series of 116 sheets within the same workbook. My primary sheet (containing the formula), has all of the part numbers (Lookup value...

Hi all I have managed to write the following code which does the job. However I am sure there must be a better way of doing it. Any help is appreciated Private Sub worksheet_Change(ByVal target As Range) Sheets("Report1").Range("B14").Value =...

Hi, I'm pretty new to Excel, and I'm still not 100% around the functions, so any help, that someone could give me on my question would be much appreciated! I have 2 sheets with similar hierarchies of 5 levels in the following format: Sheet1 Row L1 L2 L3 L4 L5 1 a b c d e 2...

Hi, i am very new at Vba. I not sure I can even do this. I've tried in a macro but it didn't work. I have a file there are multiple sheets included. One sheet contains a list of employees - that are listed in rows. There are 200+ tabs (5 to exclude), each sheet named with the employee...

Hi Friends, I am struggling to search a piece of excel macro which can do the following steps for me : 1. I have individual excel sheets in 3 folders where the name of the file is the same and an unique identifier for example : 1_test1.xlsx in folder C:\Macro\test1; 1_test2.xlsx in folder...

I've been looking through the forum for an answer, and although I've seen some very similar posts, I can't get a definitive answer for my issue: Here is an example of what I am working with and what I'm trying for my INDEX MATCH...

I have a folder with 5-6 workbooks and each workbook has multiple worksheets. I am trying a code to loop through the sheets in each workbook in that folder (which ever is selected on running the macro) copying the data from B:H and pasting the data in Mastersheet with Sheet1 name as...

Hi, I have a dropdown list on one sheet. I want to be able to see that dropdown list on multiple sheets. I also want to be able to change the dropdown list from any of the sheets and this change effects all the related dropdown lists in the workbook. I know that I could use an INDIRECT, but...