repeat data

I have a workbook that is used to calculate data. There is a range on the workbook "P2:T2" that needs to be copied and pasted to a log as a record that it has been used. My problem is I don't want duplicate data on the pasted workbook. Is there a way to look for if there is already repeat...

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

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

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

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

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 :)

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

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

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