loop copy paste

Hi all, I am confident you can help a novice like me. I want to copy one cell at a time from sheet2 (cell x2 until blank) and paste in sheet1(cell j3). I want to loop it with my code for printing pdf. So, when the cell is copied and pasted as values it will do the calculations and print pdf...

An outline of my code is as follows; 1. Copy single column of data from raw data sheets, of which there are 5 in a separate workbook, to the curve fitting sheet (different workbook). 2. Run solver on these data to minimize the sum of the squares. 3. Copy the output to the i'th row of column...

I'm tryin to copy data from Spreadsheet 1 to Spreadsheet 2. All of my data that I'm copying starts at row 7 except for the GL account value. Col A (cost center), Col F (Project) Col's G to ? are dollar amounts. Some sites may only have 2-5 columns, others up to 30 columns starting at G. G6...

Hi all -- I have a csv file with data from the Twitter API. Each row has an uneven number of data points so the two data points I am interested in -- the tweet, labeled "text" -- and the coordinate --labeled "coordinates:"-- do not fall into straight columns. I would like to line up the columns...

Hi, I'm new with VBA but did quite a bit of macros last week with the help from this forum. Now I'm stuck with this one and can't figure it out. Any help is much appreciated. I have a schedule something like this on Sheet1: <tbody> Name Mon Tue Wed John Surrey 0900-1700 Van 1230-1945 APH...

I am trying to copy data from sheet 1 (which is manually updated by users) to sheet 2 (which acts as a database). The data I need to copy consists of processes and users. Processes are listed in one column on sheet 1 (no breaks), users are listed in one row, both the number of users/names and...

I have two workbooks. I need to copy a row from workbook A and paste it 17 times on workbook B and repeat this until I've gone through all the rows in workbook A (approximately 480 rows). Steps: 1) I need to copy A1:E1, A2:E2, A3:E3....A480:E480 from workbook A to workbook B. 2) On workbook...