updating cells

hello have a range of cells that I would like to be updated if the if and statement is true. ex. if cell P23 is True and if cell ranges M25 is not blank, I want the code to clear the data in the column O25 and update the text to Working. I Would like this code to run through all cells within...

I want to calculate two cells based on the number of items I have within sixteen columns on each row. <tbody> 04 06 08 10 12 14 16 18 20 Next Total Line1 x x x x 12 Should Be 28 Line2 x x 08 Should be 10 Line3 x x x x x 14 Should be 40 </tbody> I have...

Hi! I know there have been a lot of threads for finding the unique values using macro but my problem is unique in its own way. I need to compare 2 columns from two sheets of the same workbook and find the unique value. The data that I need is from Sheet 2 column C. Sheet1 Column B has a lot...

Hi, I have no idea how to do a VBA, but got one online which nearly does the job. Basically i have 2000 columns for 4000 rows, so manual copy and paste will take days. I have a blank column between each which i need a basic formula inserted. EG in cell D4 i need (C5-C4)/C4. The macro i have does...

Hi all I think this question has probably been asked before, but I'm clearly not fantastic at transferring from one example to mine... Basically, I have an Excel sheet with 7 sheets (we'll go with A, B, C, D, E, F and G). With the exception of Sheet G, all are set up exactly the same. In...