repeat

Using Excel 2007 and getting this message on launch, followed by a long wait as configuration runs (every time). On Googling I see it's quite common and caused by some Windows update. But the instructions for fixing are many and varied. Some say repeat steps 5-8 but they're not numbered. Or you...

I'm building a pivot table with quite a few columns. By default excel puts a column subtotal and doesn't repeat the row labels. I can remove the subtotals and make the labels repeat from the field menu. I wondered if there was somewhere no subtotals and repeat labels could be set as the default?

Hi, I have a very basic question, please can someone advise if it is possible to repeat the header on all rows for that specific account? sample below in link: https://photos.app.goo.gl/fYOlD51o6b5AumBp2 Where it says sample company 1 i would like that to repeat in say column a until it hits...

Hi, I have a formula that I'm struggling with. I have 4 columns of data that repeat throughout a spreadsheet. Column H, I, J and K that contain the following data types, Text, Number, Number and Currency. These 4 columns repeat a number of times, L, M, N, O, and P, Q, R, S, and T, U, V, W an...

Hi again, I require a macro to move multiple lines of data into a table style format. The macro is required to keep the first three cells of the row as they are and then repeat down for 41 further lines. Then the next 11 cells to remain as they are, then every 11 cells for the next 41 times to...

Repeat the items: I have our company interest in corresponding cell that I need to repeat, so, <tbody> 0.50882 1.59915 1.59915 1.62267 1.59915 1.62267 0.52931 1.6075 0.50882 </tbody> Will become, <tbody> 0.50882 0.50882 1.59915 1.59915 1.59915...

Good Morning, First off any help is greatly appreciated. I've run into a formula that I can't figure out. My boss wants to see which of our employees are "repeat" offenders in a spreadsheet. To put it simple. I need a formula that recognizes a "repeat" UNDER THE CONDITION that THAT same employee...

Hello, I want to repeat spreadsheet headings at the top of every page. However, I am getting the "Print titles must be contiguous and complete rows or columns." I have tried the following: Page Layout - > Print Titles ->Sheet : Cell errors as : chose <blank> to no avail. Any suggestions...

Best shown with screenshots: i have data like this (column A and B) I want everything from column B with same A value like below: So cell A1 would be "A" then row 2, first 10 values of column b row 3 next 10 values until last "A" in column 1 space "B" and repeat any help appreciated

This appears to be very strange I have a line in code which reads NewPassword1TextBox.SetFocus It was working just fine, now it causes an error If in Debug, I delete SetFocus press Ctrl+space and repeat SetFocus, the line continues without error and sets the focus correctly. When I run the...

Hey everyone! So, what I want to do is essentially repeat a formula that applies to only one row of the sheet to the rest of the rows. I want to count all 999's in a single row, and print this number in a separate variable (named Grit_Tot_Miss). I want to do this for all rows in a given...

Hi Folks, I am horrible with my "if" statements. I hope I can get some help. <tbody> Item SEQ ID ETc Apples 2000 1 Chicken 2000 2 Pears 2001 1 Onions 2002 1 steak 2002 2 </tbody> What I need does it the SEQ numbers to do +1 if the ID shows 1 OR repeat...

good afternoon everyone. can you please help me, I have a data set & I need to copy A1:Z14 & paste as value stating at A35, I need to repeat this until the last populated row - 7 rows. can anyone help me?

Hello, I have a table that contain all of our programs user names and month of use. Throughout the table there are instances where a name is repeated signifying a repeat use of the program. I am trying to find a way to be able to see the total number of "repeat users" in any given month...

Hey guys, i have a loop in my macros which goes through a range and deletes any cells that contain "(blank)". the problem is, i have to step through the loop a few times in vba for it to delete all the instances. otherwise some cells with "(blank") still remain. Range("date").Select For...

Hi. I have 80 column headers...names being Column 1..Column 2...Column 3...etc. Lets say they span from M1 : CM1 I would like them to go down one column. Lets say starting with K1. I would like each Column header to repeat down column K 10,000 times. So it would say Column 1 10,000 times...

Hello! I am recording a macro to process sheet. Here is the code: Dim r As Integer r = Range("U1").Value i = Cells(2, r + 7).Select Range("O2").Select ActiveCell.FormulaR1C1 = _ "=SUMPRODUCT formula here.... Range("O2").Select Selection.Copy...

I need to input data into a column. There are 34 different data sets, but they repeat after 34. All the way to around 3000. What is the best way to do this? I know this is probably simple but I haven't found a way to accomplish this after a lot of searching. I have provided an example below. The...

Hi all, I have Report A....it has 4 columns of data, A: Date, B: Rating, C: Type, and D: Finding....with 215 rows of information. In report B, I have a running list with the same breakdown, but 132 rows of data. In report B, columns A-C have different combinations still contained within Report...

I have a spreadsheet with 3 columns: First Name, MI, and Last Name. This spreadsheet contains thousands of names, many of them are repeat customers. How can I count the occurrences of each name? For example: A B C Michael J Smith