repeat

I have a list say: A,B,C,D,F (IN COLUMN A) I want the user to select a member of the above list in column B1 and say how many times it must be repeated in column C1. The extracted list can now follow in any other column (a multiple of times say 2) Example. User selected A Repeat 3 List 2 times...

Is it possible to modify the cells located in the "rows to repeat at top" when printing each page Thanks. Jim

in a cell H3 i have ref to =C3 i need H4 to ref cell =B3 i need H5 to ref cell =C4 and repeat down many rows . if i copy down excel doesn't work out i need the pattern to repeat. how can i simply copy down? i.e then in H6 need =B4 H7 =C5 H8 =B5 and so on TIA

Hello, I'm new to VBA coding. I found a very useful code that allows me to produce a checkmark when I double click on the task I've just completed. However, for some reason, I can't repeat the action. See code below: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...

Hi, I have id's numbers that repeat and i need to count them with the same "row number" the formula I've come up with is: =if(b2=b1,"1",a1"+1"). each change in employee number it starts over to row number 1. what am i missing <tbody> Row Number ID Number 1 123421 1 123421 2 222323 2...

Objectives: 1. Transfer cell components of column B to F in Excel to a designated place in Word 2. Must retain the format of the destination 3. Repeat the process a number of times equal to the number of rows after row 7 (I think the way to do this is to manually input a value in a separate...

Hello everybody I need same help. I need to delete rows with the value 0 in column B I made this: Columns("B:B").Select Selection.Find(What:="0", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _...

Hi, I'm trying to calculate a tourism streak for attending different running events. So I have a list of events and I want to work out the maximum number of times someone has gone without repeating themselves. So in the example below the longest streak without repeating is 8, between the two...

Greetings, Example: I've got data in Row3 A2 B2 D2. Once that data has been reviewed/confirmed, I need to COPY/PASTE it over to M2, N2, and Z2 on the same Row. Then wash, rinse, repeat down each Row. Might that be possible via a Formula? I can't seem to find anything. Or would this be...

Hi Everyone, I'm wondering if there is a way to populate a DLookup in a cell based on the population of another cell in the same row? For example, Cell D2 is populated with a Scan as text. When that happens I would like to populate cell H2 with the formula below and then repeat that in each row...

Hi, I want a my first row of a long document be repeated not only in the top of each printed page but also in the middle, is it possible ?

Wondering if there's a way with VBA to do the following. I need to get the data in C:2 and D:2 into E:1 and F:1, the data from C:3 and D:3 into G:1 and H:1. I need to repeat for the entire sheet. Can this be done with VBA? https://drive.google.com/open?id=189R34HQhkflk6wh-mlxhj6aJtblTX5Ed

so in a pivot table i recently learned you can choose to repeat or not repeat a columns fields by right-click / field settings / layout & print and then checking or unchecking the Repeat Item Labels box. The last few times I've tried to though that box has been grayed out. Any guesses as to...

i'm trying to learn a few new reports at work. one of the things i need to do is based on a pivot table. i've been able to create the data just fine but i'd really like to make it look like the previous person who did this. i can't seem to find a way to see all the formats applied to a pivot...

Starting at F35, looking to sum the first 4 cells, then in the next cell sum the next 4 cells, then in the next cell sum the next 5 cells in row 35. Then repeat. If I am summing 4 cells every time, I use the formula below - not sure how to sum 4, 4 then 5 and repeat...

Hi I want to use Repeat() to type "*". My question can I color these "*" to different color depends on the reading? Thank you. <tbody> day tmp =repeat("*",A2) mon 15 ************************ tus 10 ****************** wed 4 **** </tbody>

I am trying to learn loops. My vba code is: Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection...

Hello, I am trying to delete blank cells to the right of Column E, until its filled with value "BU" or any value really I need to a loop that goes to the last row. So if G2 has BU, then look at E2, No value, then delete, move left, repeat, until E2 has BU Can you help please. Ross Thanks Ross

Hello, I want make a calculation and if negative to make it zero, while if possitive to leave it as is. I write it as: []=IF(($D$123-D30*$D$10/$D$21)>0,$D$123-D30*$D$10/$D$21,0)[] Is there a way to make it shorter without having to repeat it twice in the formula because it gets very long...

Hello I download results from multiple searches using a loop, but in some cases website reads your search time out. However if I manually re do the search it works. So, I would need to re-do or repeat the same search and then continue as usual. I would like for the code to re-start the...