repeating

Hello, I have a long repeating angle/circular sequence as example below which repeats at every 360 degrees. I wish to add 360, 720, 1080, 1440 (circles) at every turning points so I get an ascending sequence. <colgroup><col><col><col></colgroup><tbody> Original sequence Desired result Note...

Hi, I have a series of IF functions, and if they all 4 of them return negatively I want it to run again. The first IF is based of a RANDBETWEEN function so it would give a different result, not resulting in a loop. I have tried code such as Sub Worksheet_Activate() If...

I am trying to set up a query for reporting purposes. I have a table with activity codes that has two fields [FieldA] and [FieldB] which are linked to one other table each that has rates associated with [FieldA] or [FieldB]. I ran a query by just pulling in the table with activity codes and it...

Hello, This is my first post, so I apologize in advanced for any errors or novice interactions. I have noticed that the Rnd Function repeats exactly the same pattern each time I close the workbook. I am running a dice macro for a board game. It is turn base for 7 players, after each roll the...

Hi, i want to repeat this macro 2119 times, but from cell c5 it need to paste 5 rows down, so it has to past in C10, C15, C20 etc. until thats 2119 times done. how can i do that? this is the macro. Range("C5").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection...

Think I've done this before but can't recall how. I have a single column with large no. of rows. There are several repetitive entries in the column. What I need is another column showing each entry only once. I hope it is clear

I have a list of accounts that has charges made against the various counts on a daily basis. Each account has a unique 7 digit project code that is associated with it, listed on the master log/ list of charges. On a seperate reference worksheet, I have a named range called "LU_PROJECT." I...

I have a sheet where I repeat the same formulas for different items every 41 lines. I have created graphs that fit within those lines and are based on the information gathered and calculated there. I tried to make the references for the graphs relative rather than absolute, but excel auto...

I appologize, but I don't know the correct lingo for what I'm trying to do. I searched the forumns and I'm sure it's in there, but I probably don't know the correct key words. Column A has a list of names (some repeats). Column B has numeric values. I want to count all the Column B values...