a20

Hi everyone, Have a request for a formula. In cell A10 I have a value of 1 Cell A15 I would have the formula that would do the following: I know the value 1 is in cell A20. I want to count how many times the value 1 repeated below cell A20 before the value changed. So in the example below...

Hey all, I have 5 dropdowns in column A (A8, A11, A14, A17, A20) I want to be able to clear 14,17,20 only (20 is dependent on 17, 17 on 14). So if I have a selection in these cells and I change cell A17, I want A20 to clear out. If I change A14 I want A17 and A20 to clear out. I have the...

hello I have 20 sheets named 1,2,3....20 and one sheet named "report" In every sheet I have 20 rows of data. I need to put all data from each of 20 sheets to report sheet It means A1 to A20 from sheet 1 will go to A1 to A20 on report sheet. A1 to A20 from sheet 2 will go to A21 to A40 on...

Hi there, It has been a very long time since I have been on here :( I have a problem which I do not know where to start. I have a cell (a5) where I can change the part number, and I am trying to lookup to a photo that will be in any one of multiple folders and return the image to cell a20...

Hello Folks, I need a vba code that can help me drag down a formula across filtered cells without a reference to the hidden cells. For example. With cells filtered as follows: A4 B4 A7 B7 A15 B15 A20 B20 The formular will be as follows: A7 = B4 A15 = B7 When I drag...

Title says it all, I need help in making a macro that simply fetches all rows starting at 1 to 20 for example, and then highlight all rows that have the same exact information in its many cells.

Hi, I need to have a messagebox prompt depending on a cell value. If cell A20 is NOT "Yes" and the user chooses "Yes" in cell A22, then a message box should prompt saying "This option is only possible by enabling A20" and then if the user presses "Ok" in the message box, then cell A20 should...