repeat

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

Hi all I want column F to summarise all text data detailed in columns A, B, C, and D, but only showing one result no matter how many times the same entry occurs in A-D. EXAMPLE: A B C D E F <colgroup><col width="64" span="6"...

I am trying to write a Macro as i have a lot of data, but due to the format it doesn't pick it up as a number only as text, so i have to click into the cell and press enter to turn it into a number. So i have data in column K and want to say if K2 contains data, click into the cell and press...

I have a group of random, possibly repeating numbers in column A and another group of non-repeating numbers in column B. I ultimately want to highlight the numbers in column A that are the same as column B's numbers. I could do this with the default highlight conditional formatting rule, but...

Hi all, I am rather new to Visual Basic, but I am trying to duplicate a function that I have wherein if an amount in cell N165 is greater than 5000, then the two rows below the cell (in this case, rows 166 and 167) will become visible. I am trying to do this in multiple separate instances on...

Hello, I have recorded a macro which I've modifed to accomplish what I want. Basically I have a 2 worksheets. ControlSheet : which has a cell that contains my "criteria" and a button to run the macro DataSheet: Which holds that data that will be modified based on the macro. The user is able...

I know you can make static rows repeat at the bottom with custom footers. However, it is limited to what footer options allow you. I wanted to see if there was a way to make rows repeat at the bottom that had formulas written into it. It is preferable to do so with out macro help as well. I...

So, I am fairly competent with excel formula but no nothing about macros. I have just received 35 separate pdfs which I think will convert to around 15000 rows of data in excel. I think it will take me hours (if not days) to formulate the data in to a usable table without some kind of excel...

Hello everyone, I would like to get you advice on few issues I am having with powerpivot DAX please. I have several data from diverse product. Each product change its price one or more times per Month (normally one) and not all months. What i need is get a pivot table where i can see a...

I'm trying to create a basic macro but I'm not a programmer what-so-ever so I was hoping someone could help. What I'm trying to do is: Copy A2:A3 and Paste in A5:A6, repeat process by then continuing to paste into A8:A9, and so on (skipping A1, A4, A7, A10, etc...) Any help is greatly...

Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 To become: Column A AAA_BBB_0002135 AAA_BBB_0002135 AAA_BBB_0002135 AAA_BBB_0002135 AAA_BBB_0002136 AAA_BBB_0002136 AAA_BBB_0002136...

Hey guys , so I got this macro below but I want to introduce a loop or some way for it to repeat itself 13 times, i ave got a range that I coy and then paste transposed. Any ideas ? Sub Macro35() ' ' Macro35 Macro ' ' Range("B18:F20").Select Selection.Copy...

Hello, Here's my first ever post. Thanks in advance for the help. I'm in sales. I downloaded every transaction made for 2013. The final tally was 7442 transactions. There are 546 different sales people. I have a single column with the name of the salesperson who completed each particular...

I have a code that creates a zipped file that saves to the desktop. The macro works fine except it repeats itself and doesn't stop. How can I change the following code so that it only creates one zipped file? Sub WhichButton() Dim strDate As String, SavePath As String, sFName As String Dim...

Hello! I'm new to this forum. I have the following code but it only works for the first line of data and I need it to loop through an entire list of data. Can someone show me what I need to add to have a loop work? Sub Appointments() Const olAppointmentItem As Long = 1 Dim...

Hello - I'm new to these forums and I have a problem that seems simple but is somehow evading me at the moment. I haven't been able to find a good answer yet with a search so I figured I'd ask y'all. I have a table of items in Column A and the number of times I want it to be repeated <tbody>...

I am looking for a way to drag down a table so that the table repeats with links to diffrent sheet. But when I drag the cells down they repeat but jump. For instance If I draged the cells bellow. It would make links to sheet2 a5 rather than a3. It will take me a life time to do this manually...

A predecessor has incorrectly spelled a word and I don't know how often it occurs in the numerous spreadsheets so wanted to create a macro which would quickly search each sheet within a workbook, correcting any that it found. Have successfully used the 'for each wksht in worksheets' approach...