repeat

Good afternoon, Please can you suggest me a vba code to replace this one below: ActiveCell.FormulaR1C1 = "=VLOOKUP(Sheet2!RC[-1],R1C1:R109C19,7,FALSE)" Selection.AutoFill Destination:=Range("B2:B15693") this just copy the function to every cell in the column and i don't want this because i...

I have the following VBA code and want to repeat it across multiple worksheets on a workbook. --------------------------------------------------------------------- Option Explicit Private Enum Nwc ' Worksheet columns ' 17 January 2018 ' assign any...

Hey guys. I have a customer order list for my e-commerce website and I am trying to find out my repeat buyers as well as my biggest buyers. Here is an example of how it looks like: <tbody> Email Product Bought Total That Customer Spent customer1@email.com shoes $5 customer2@email.com hats...

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...