vba & conditions

the cells have a number associated with it which looks something like this ,column A & B will never have any color the columns and rows are dynamic the Output is expected something like the below. the green columns B-C should only be populated when the whole line is green and only first...

Hello, I am fairly new to VBA and I was given a task regarding it, I am using MS Excel 2010. Here is my attempt to explain my end goal and code I've written till now to reach the same. Workbook1 has Sheet1, Col A has `uniqueProductID` from company A Col B has `Price` Col D has `uniqueProductID`...

Hi I am not able to progress after getting output got cell J11. Looks like the loop isn't working. I am looking to get the month end dates in the row 11 from the start date to end date. Can any one please help me to resolve this?

Hi Gurus, Good day! Could you provide your insight on how the macro can paste the data from a worksheet to another with merge cells? Workflow: 1. I have a main data worksheet and files to update. Files to update on this case is same with State provided in Source worksheet. All State data...

Hi all, I'm chasing a VBA macro urgently but don't know how to go about it. Thanks in advance, please see below: There are 3 documents, I have links to them below: Doc_1: Loading Google Sheets Doc_2: Doc_2.xlsm Doc_3: Loading Google Sheets What I require is a VBA macro in "Doc_3" which when...

My VBA macro runs reports from Excel to generate a Word doc with upcoming deadlines/due dates. However, I can't figure out how to include a description of the upcoming deadlines/due dates when I run macros. Here are the columns that I need help with: COLUMN A = MATTER NAME COLUMN K = TASK...

Hi, I have a market analysis sheet which is shown in the picture. As seen in the picture i have a column "p:p" where i can type in a date for each row. I want to make a code that colors the whole row green if its less than 1 year to the date, yellow if its more than 1 year but less than 2 years...

Name Status Email Status2 Comments Carrier Chk1 James Smith Provisioned JamesSmith@gmail.com REGISTERED Luke VzW Christopher Anderson Disabled ChristopherAnderson@gmail.com PENDING VzW Ronald Clark Disabled RonaldClark@gmail.com REGISTERED VzW Mary Wright Provisioned...

Hi there, I want to create a macro where I can find and replace the wording of my data in one column depending on the condition of another. I would like to search column A for "Scotland" and "Southern" then if column J is "SHIPPER" change column A to "Scotland Transport" or "Southern...

I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high) If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column If I choose High to low my pivot should get sorted in...

Hello Gurus, I'm currently have below code DATA 1 Sheet: ITEM 1 ITEM 2 ITEM 3 ITEM 4 DATA 4 001 002 003 Note: In cell E1, that is the Sheet where the data should be look up. Usually, manually filled as there are too many data sheet tabs. In the code below, it...

Hello Gurus, I am trying to create a macro where in if the cell value in the MAIN sheet matches one with the hidden sheet name, macro will unhide it. By the way, those Data x Sheetswhere hidden because there's too many. Example: In the MAIN sheet, if cell Value in A1 is "DATA 1" then it...

Hello Gurus, Do you have any thoughts on how to code this scenario (see image below)? I was thinking of using Cell I2 in SHEET 1 as reference in order to pull the info from the different sheets (specific Data sheet and Others sheet). Appreciate the thoughts. :)

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

Hello All, I'm trying to write code that allows me to make negative numbers purple, positive numbers as orange and unchange as black. Basically, I need to reflect this for all sheets particularly Column L:N except for the tab sheetscalled "Results" and "Others". Colors for Change: Positive -...

When the item-list is selected in the range in particular cell, the Shape button should be visible on the side. How it possible to make this hyperlinkbutton in table

Hi, Thanks much in advance for reading. It's really not an overly confusing concept, and I've tried to lay it out as simply as possible! I have some VBA code (not my own) that successfully returns combination sums between a defined range. A quick summary of what that even means, then my issue...

For Each sht In ThisWorkbook.Sheets If sht.Name Like "DHU - *" Then sht.Visible = xlSheetVisible End If Next sht I've got this code that keeps erroring out on mismatch 13. I'm not sure what's causing it. It gets through the loop like 8 times and then says that...