maco

Hello I am having a bit of trouble interpreting some of the answers that are out there, I would like to do the following conditions Custom formula is =$J3=TRUE -> green highlight - for cells A3:J999 (or end of sheet) Custom formula is =NOT(ISBLANK($I3)) - no highlight - for cells A3:J999 (or...

Hey guys, I'm running into the issue where I would like to create a drop down in each cell in the range h4:h74, and for each drop down, have each drop down reference a new data set from B86:BT86. So for cell H4, the drop down in that cell should reference B86:some ending point, H5 should...

I am running code when a worksheet comes into focus using Private Sub Worksheet_Activate(). How can I run a code when the worksheet looses focus?

I need a maco to change the value in column F from 1 to 00.

Hello all, I have a worksheet, where in Column F, there are about 200 instances of a cell containing the text "EBITDA". I have used a macro to insert an extra row below each of these instances, however I'm looking to copy and past the contents (formulas & Format) of Row 31 so that it can be...

Ok everyone, this is what I'm trying to accomplish, I am trying to create a macro that will be operated by a button that will format a range, then a selected range is saved as a PDF to any users desktop and THEN attached to an email followed by more formatting inside the excel sheet. I feel...

Hi All I currently have the code below that copy's data down in rows one after another, but I really want this to now go via columns now and not rows. Can anyone help? Thanks Sheets("Pivot_Table_Non_Closed_Area").Range("D12:D21").Copy 'Pastes the data from the sheet above in the next...

Hello, <tbody> I currently have a list of banned words which I have named "content_check" and are in a tab called "Guide". I would like to make a macro which will check cells G13, G15, G19, G21 and E30:E6000 (if not blank) in the tab "A+_Creation" and highlight in red any words which match...

what data i have? • Row "1" of sheet 1 is full of data in each cell. what i want to do? Step 1: I want to copy six colums from row 1 ( i.e. data in cells A1:F1) and paste in sheet 2 row A1:F1. Step 2: I want to copy next six colums from row 1 ( i.e. data in cells G1:L1) and paste in sheet 2...

Hi Guys, Im relatively new to the world of Excel VBA and have written the following code: The macro itself is linked to 2 buttons, one for Start/Stop and a Clear Button. When pressing Start it updates cells in M18, pressing stop updates N18. Pressing start again then updates M19, and stop...

Good Afternoon, I have a workbook that links to 12 different workbooks. I am looking for a macro that will break 10 of the 12 links. For ease assume the linked workbooks are saved as A.xlsx, B.xlsx, C.xlsx... I am looking to only break A and B. Any help would be greatly appreciated.