repeat

  1. B

    List all data from 4 columns into one column without repitition?

    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"...
  2. P

    MACROissue

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

    Possible to match one group of cells with another group, but only in one direction?

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

    Repeat VBA Function for Separate Events in Same Worksheet

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

    Creating LOOP within a macro

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

    Repeating rows at the bottom with formula

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

    How to transpose data from column to rows multiple times - macro?

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

    Last Price

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

    Copy & Paste then Repeat

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

    How to repeat a row 4 times, while increasing sequence

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

    Repeat Macro Transpose

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

    How do I count multiple repeating values in single column

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

    Macro won't stop creating zipped files

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

    Need to loop Macro for an entire list of data

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

    Repeat a cell multiple times based on a variable

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

    Complex Dragging of cells

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

    Macro to repeat a Search and Replace on every worksheet

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

    VBA - Copying a line to the next non-blank line and repeat - help

    I have several large documents that need data filling in and I'm trying to work out the best way to do it. I need the contents of A and B columns copying down the rows to the last blank cell then the same again for the next non blank cells. I'm hoping someone can help - also if there's...
  19. W

    Counting repeated cell values

    Hi, How are you guys??? I was reading and searching the forum to find if anyone has my same question but I found that the things I found were quite different. Going to the point I need to make this thing: I got 1 column that has different and sometimes repeated values: <tbody> Cells...
  20. Nathalie Sicard

    Create a matrix of data automatically

    Hello, I have a problem that I need to get solved to make my work more efficient and I'd like you to help me, I'll appreciate it very much. I have 2 types of data: Product & Store And the data would go like this: A Corn Flakes Frosted Flakes Froot Loops B Store 1 Store 2 Store 3 Store 4...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top