paste copy range

Have a few questions about the most efficient way to copy data from one worksheet to another. Have looked at a few texts, references online, including this forum. Below is what I have so far. It works, but I suspect it is awkward. Looking for comments and suggestions. Thanks. Q1: Is there a...

I have posted a question in the past, but, as my requirements are now considerably simplified, it is easier to start again from scratch. I am working from the code below as a base. Its purpose is to select and copy the current row, insert 11 rows below it and paste in the contents of the...

Hi, I have scenario below for copying columns data and pasting into seperate tab within file. What I want is, copy columns from E3 to J to last row of data that mentioned and copy into "Record Allocation" worksheet within file. At the same time, when ever this macro runs every time it...

Hi all, I'm a newly registered member but have been a stalker of this site for the last week to try to learn the basics of macros. Was hoping someone could help me with my problem. I am trying to copy a range from Workbook1 and paste it in to Workbook2, in a cell that is defined by a number in...

Hi all, I am trying to build a macro to perform what I thought was a simple instruction but has turned out to be a nightmare. Scenario: My sheet has filters and I want to remove the listings (15 cells per row) where column 5 filter = 100% I then want it to paste into another sheet and then...

Hi guys, I have a range ("B2:J" & Last Row) which takes an input, calculates, then I wish to paste the results to the last row of another sheet. I could do it with an ordinary selection.copy and paste, but the loop runs approx 4000 times and is rather slow. I found some efficent code I am...