a21

Hi, can you please help me with this. thank you I have 21 worksheets I will refer to all my worksheets by codename Cells A2 through A21 of Sheet1 contains a list of PO Numbers. I want worksheets 2 through 21 to be renamed based on sheet1 cells A2 through A21. example : if Sheet1, Cell...

So i have a cell with which as the following in it - 100 > m > 10000 - In my case its in cell A21 Is it possible to write a code that seperates the 100 and 1000 to another variable?

Hey Everyone, I was hoping someone would be able to help me with what I think will be pretty simple. When the user clicks a cell in column A, take that cells value subtract 10 and highlight that range in the column. For example if I click in cell A21 (3113)-(10) = 3103 So highlight A21 to A17...

I have a list of dates with blank cells in between at various spaces. I need to add 7 days to the date above it no matter it's location (not the last value in the column). Is this the most effective formula I can use to do this? Sometimes it seems to get hung up and not calculate. Here's an...

I am hoping that y'all can help! I am trying to get a formula that says, If A21 says Nickles do =((B21+C21)-D21)*2 If A 21 Says Dimes do =((B21+C21)-D21)*5 The list will change and say Quarters and change the last multiplier to *10, Ones *20, Fives *40, Tens *40, Twenties*80, Pennies...

Hi, For my own use and to replicate a childhood game I am trying to construct a cricket match. So far I have: A21=INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A))) to return scores between 0 - 6 including OwZhat Then =IF(A21="OwZhat",A19,"") which in turn triggers A19 =CHOOSE(RANDBETWEEN(1,2),"OUT","NOT...