vba copy / paste

Hello All, I have a problem in writing a code to copy and paste multiple times. I have 2 sheets, where in sheet 1 I have 160 Rows and 3 columns. I need to copy each row and paste 15 times in sheet 2. can anyone help me to sort it out.

Sub Macro2() Dim ws As Worksheet, MasterSheet As Worksheet Dim originalDestinationCell As Range, nextDestCell As Range Dim firstGreyCell As Range, rangeToSearchIn As Range, c As Range Set MasterSheet = Sheets("Sheet1") 'where you want to put the copied data Set...

Good morning, I have an excel file, which contains property ID in column A and a value in column B. The IDs are repeated. I want to move the value to one row, so there will be no repetitions. Here is the data and here is what I want to achieve. I have made a helping column with value T, which...

Good Afternoon, I have a workbook which opens to a userform for the user to enter name and year. Once entered the submit button copies a master sheet for 12 months with the entered year and hides the master sheet. My problem is I need a macro which can copy data from a cell on the ActiveSheet...

Hi All, So I currently have a testing document which includes testing information. I just got the code to work for inserting rows based on a particular cell directly below that row. Now i need help figuring out how to copy certain cells from that original row into the new row and loop...

Hi I have a worksheet named "Required Data". In column A is a variable range of numbers (1,2,3,etc) and for each number there is a corresponding worksheet (named 1,2,3 etc). I need to copy the data in columns D:M and paste it in the 1st empty row of the corresponding worksheet e.g if A2 is 1...

I am in need of a VBA to copy range E2:O100 and R2:AJ100 and place them on a new worksheet starting at the third row Column E thanks in advance for any and all help

I'm trying to create a macro that will take a daily pre-designed format sheet (people just input the numbers in to rows, and columns) and insert them into a combined yearly master. It will copy all the rows just fine it seems at the moment, but it stops at column CD and I need it to go to CQ...

Hi, I am looking for a bit of steer on some VBA that will allow me to: - Double click on a cell within a range (C11:AI24) - On Double clicking, it will take the content of the cell I have double clicked on (could be any cell in the above range) and pastespecial values into a different cell...

Hi Guys, I was just wondering if anyone could help me with the below please. I am looking to have all the values from column A Sheet 1 copied to Sheet 2 a1:cm1 but is it possible that once copied that the macro would run through and name that range based on the value in the top cell a1:a5...

Hi Guys, I was just wondering if anyone knows how to copy Row 8 From Sheet 1 to A1 in All Sheets in the workd book. Many thanks Jamie

Basically I have an overview document that compares several different sets of scenarios. Let's call this Overview.xlsm. I have many many scenario results with various names. Each of these scenario workbooks is formatted the exact same and was populated from a standard template. Let's just...

Hi I would like to copy a range of data from one workbook to another using vba. Both workbooks are already open from a previous process. Please could you help? Many thanks

Hi I have a formula in cell Q2. Using VBA, I would like to copy this down to the last row of column P Thanks in advance for your help

Hey there, I'm looking for something somewhat complex but I'm hoping there's an expert out there who can help me. I have one master workbook that I use to manage multiple ad campaigns. I'm trying to pull data from multiple workbooks into this master workbook based upon certain criteria. Let's...

Hi Everybody, actually i want to use vba to copy a range of data to another sheet. For example i have two worksheets. Sheet one named Invoice List which contains a table as follows Date Bill No. Amount Payament Status 1/8/14 1 100 pending 31/7/14 2...

Hi, In order to do the tests, I'm using 2 simplified workbooks (test_copy and test_paste). What I'd like to be able to do, once I click a button UPLOAD (creating the button isn't the problem), is to go to the first cell from workbook test_copy, check if that code is already on test_paste and...

Hi, I am very new at VBA. However, I'm working on this tool, where I need to develop the following in sequence: 1. User has to browse for a particular workbook 2. User then selects the sheet required for copying 3. User then selects a rage of columns required to be copied 4. This tool copies...

Hello Everyone, I don't know if I am violating forum rules with this post, so if I am, please let me know and moderators act accordingly. Recently I posted a topic called http://www.mrexcel.com/forum/excel-questions/709680-need-visual-basic-applications-help-dashboard.html#post3504562...