copy & past rows

Hi folks, I am having some trouble executing some VBA, I am trying to find the last row on sheet one and then select 100 rows from the last row up and copy, however I am getting run time error 1004 application defined or object defined error; I appreciate some help here; here is my code...

I have 80 excel files in a folder. The structure of each file is the same meaning beside the file name which us different, the file content is a table which is identical in all files. The files have the same amount of rows and columns. Column headers are same. Column a is the date column. Every...

Hello, I've come to a problem that I have really not even an inkling of how to solve (normally I will spectacularly fail multiple times before searching for answers). In Cells D8:K8 I need to have data copied to that range. Somewhere between row 23:110 There will be that data in columns...

Hi, My ability using Macro's is limmited so please excuse the bad code! I'm trying to use VBA to transpose and paste data from one sheet to another. I can get the first row and the start of the second as B:B will always have data, however C:C may have blank cells depending on the avaliable...

Hey everyone I'm trying to design a workbook that will copy an entire rows data to a seperate tab once a dropdown selection (in that same row I'm trying to move) is switched to 'Completed' Is there a way that a Macro can be triggered once that "Completed" dropdown is selected which could...

Hi! I need a macro that can find multiple identical values in column A, then find the min and max values of column B and delete all other rows. Example: A worker comes to work and registers at 7:55, at 11:00 he registers for lunch and comes back 30min later. At 16:05 he leaves work and all I...

Hi Everyone, I'm new to writing code in macro's. I have a requirement where in i have to copy visible rows except headers from one sheet say sheetSS and paste them to other sheet say sheetRD for particular number of iterations. User can manually filter the records in sheet1. there are 5...

I'm pulling an ID from a seperate Workbook that lists the the IDs in Column D vertically. I have a sheet that I need to copy these ID's to, but the formatting goes horizontally. For example, Assignment 1 Assignment 2 Assignment 3...

Hello, I've searched to try and find the answer to this question but not having much joy so any help will be greatly appreciated. I'm relartively new to excel VB codes and my seemingly impossible task is shown below: * I have a list of data each one has 6 rows of data. * (Rows...

Hi, I have vba which works very well, it copies down to the last row and will paste on the first empty row, however when it is copying it skips blanks, does anybody know how my code could be modified so that it will copy and paste blanks? I'm copying and pasting from multiple workbooks so that...

I need to copy data from workbook a starting at line 2 and paste to workbook b starting at line 3. I would really like your advise please I have been trying to piece together other answers to get my answer but am failing :)

Hi All, I'm looking for macro code to copy paste the data into different sheet. I would receive different files every time with same format but heading will not be in same column (but all columns will be there but not in order every time). My concern is how to copy the data which has unique...

Hi Team, I need your help in order copy and paste the data from different excel sheets to one main sheet. I will get a file which may contain 10 sheets or 15 sheets depends on data and rows also not sure it varies from sheet to sheet. Now, I would like to consolidate all the sheet data except...

I wish to speed up my Monte Carlo simulation. I'm reading that dumping values generated by a loop into a VBA array, versus into Excel itself, followed by then dumping the completed array into Excel cells (if I need those values, which I do) is much faster. I've been reading about arrays all...

Dear Good People in MrExcel, I want to plot a graphic with a non contiguous data, so I figured I should move the data to another place and make them contiguous. The problem is I have around 9000 data in one column. How can I move just row 1,4,7,10, etc (every 3rd row) to another column? Is...

I have a worksheet containing 6,000+ item from my hardware store. I want to create barcode labels for item numbers keyed in. The flow would be..... 1. key in an item number via (input box) 2. macro to find that item number in column of sheet <1> and copy the row to sheet <2>. Then back to...

trying match a cell value to another sheet within the workbook (sheet1 cell A1) like a Vlookup but when it matches in the a column of Sheet 3 i want it to copy the row and paste it in A5 on sheet1. here is what i'm using right now.... Sub copyit() Dim MyRange, MyRange1 As Range...

I am an excel beginner so need help. I have 8 columns in Sheet 1 and hundreds of rows. In 'H' I have one of three different options 'Adam', 'Bob' and 'Chris'. I would like the entire row copied to Sheet 2 if Adam is chosen, entire row copied to Sheet 3 if Bob is chosen and Sheet 4 for Chris...

Hey guys, I am wanting to copy certain rows (which meet a condition) to the current selected sheet in an excel document, to create a daily report of current jobs. My work flow is: I have a register which each work request goes in. Each request is assigned a status, whether it is an "Open"...

Using Excel 2003 in XP...I have a database worksheet ("DATA") that I want to copy certain rows of data to multiple worksheets within the same workbook ("KING", "PIERCE", etc.) if it matches the County (e.g. King, Pierce, etc.) of the same worksheet name. Worksheet DATA has 3 header rows and data...