repeat data

  1. J

    Copy Column With Values n times in excel

    Hi all, I have been going through all of the possible answers in Mr Excel and none of them seems to fit my specific problem. I would just like to have a scenario like this: 1 2 3 4 5 This must be copied horizontally n times. Thus lets say A1 = 5, then the output must be: 1 1 1 1 1 2 2 2 2 2...
  2. N

    Limit number of times data can be used in a row

    Hello all, I am using Windows XP (soon to be switched to Windows 7), and I'm creating a scheduling form in Excel. I would like to limit the number of times users can put the letter "r" into a row (which defines the dates in the Payperiod. The limit is 8. I tried to come up with a way to use...
  3. L

    Excel as a Database for MailMerge -- How to Produce a List with Variable Results

    I am using MSExcel as a database to produce a document in MSWord via MailMerge. The database needs to be able to create a list of signatories that will vary depending on the document. For example, Mary, Joe, and Laura might need to sign Documents 1, 2, and 3, but only Mary and Joe will sign...
  4. H

    Rept numbers & names by using VBA/excel funtion

    Hi All, I'm looking for one function/vba code which needs to repeat the required cell value based on the given condition. Example: Manual Data: <colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody> Number 8 Names % Rept No A 40% 4...
  5. A

    Autofill values

    Hi All I need a macro to repeat the last value in the column A depending on the Number of values present in the Column B. Ex: ColA Colb Dad 56 Mom 78 Son 67 89 78 So the value "SON" should be repeated until the 78 in the column B. Thanks in Advance :)
  6. H

    Please help!

    I am looking to write a macro which will write information from 7 columns of information into a new spreadsheet. For example, my data is: Col A Col B Col C Col D Col E Col F Col G Name1 Measure 1 Length 1 Width 1 Height 1 Diameter 1...
  7. sudeep

    Excel as Database - Word merge unique records

    Hi. I am trying mail merge my data file in excel with word. I want the word doc. to have all un-repeated portions of the data. Basically, I need to send letters to all my customers giving a statement of their account containing their cheque details and demands raised by us. A snap shot of my...
  8. M

    Chart and Sorting Help

    Hi, I have a question about creating a chart from two columns. In the first column I have different text entries, some of them appear various times. In the second column I have percentages attributed to the data of the first column. In my chart I want to have only one outcome for each text entry...

Some videos you may like

This Week's Hot Topics