copy & paste columns

Hi, I wonder whether someone could help me please. I've put together the code below which copies data from non sequential columns. Dim lRow, lCol As Integer Sheets("Amalgamation of Search").Select lRow = Range("A" & Rows.Count).End(xlUp).Row lCol = Cells(1...

Hi, I wonder whether someone may be able to help me please. From searching on the web I've found the script below which copies a range of columns from a specific row, until the last, creates a new workbook and copies the data into the new workbook. Dim lRow, lCol As Integer...

Hello, I'm trying to figure out how to make a macro that copies all columns named " Current Projection" in row 4 and pastes them right after each other. So wherever a column says "Current Projection" in row 4 i pretty much want that column to be duplicated. I tried doing this myself but of...

I am trying to write a macros so that a given column will autofill a given range based on the last cell. Below is an example to better explain what I need: Michael Michael Richard Richard Tyler Sam Sam Billy Billy Chad Chad Pretend these given names are all in the same column (lets...

This forum is really helpful. I have been learning so much from the forum users. First of all thanks all :) So I have below questions regarding creating multiple workbooks from one sheet. My steps are 1. There will "first.last name" in Column A. Sort column A for A to Z.. 2. For all unique...

Basically what i want to do is copy the date below a column header to another sheet in the same workbook based on the header. This will be used by multiple people and each report will have different column arrangements. I will have three sheets within a workbook. Sheet 1 will be called ''paste...

Hello, New to the forums here. I have searched multiple threads and am struggling to find an answer. I have a conditional formatting formula "=$G6<>$H6" set up to highlight numerical differences in two cells. That part works fine. My range is set to the two columns being compared...

Hi can i paste cell selection multiply times each after 13 rows, the number of how many times to be pasted to be from a cell eg. F1(12), also some formula in that are in the selection range to be updated automatically with the row number til to the number in cell F1 eg. =A1+B1 to...

I am very new at VBA and really need some help with a piece of VBA code. I receive a file from someone that has a Heading (maybe in row 2, row 1, row 3, who knows) The heading labels are at least consistent. I have a master template that I need to copy the data beneath each heading of their...

Hi, I'm new to all this but have been able to receive a lot of help just by googling my question and finding it on your website. Unfortunately, this has gotten me only so far in my project and I figured I might as well create an account with you guys and get specific help tailored to my needs...

I have a sheet with multiple columns they are of varying rows: <tbody> A B C D E F G 1 Header 2 Reading Number Date Channel 1 Channel 2 Channel 3 Channel 4 Channel 5 3 1 09/08/2015 1 4 2 09/08/2015 3 5 3 09/08/2015 0 6 4 10/08/2015 1 7 5 10/08/2015 3...

So I've got three sheets of data that have different columns. There are about 10 columns that are similar in all of them, and I'd like to be able to copy and paste them so they stack together under each other. The issue is that there are different product classes after every hundred or so rows...

Hello all! I am working with the below code to attempt consolidating all of the Excel files within a folder (File1, File2, etc.). I have created and renamed sheets in the blank workbook (named "cExcelFiles") to match the sheets in the files I will be copying data from. The sheets all share the...

I have been trying to achieve this for a while. Thank you in advance for your help. This will be a script that will be based on 2 excel files: fileA and fileB (if you can't do this with different excel or sheets then consider having all date in one sheet but in different columns, obviously) use...

I am new to VBA so all help is much appreciated. in sheet1, column AW contains values I wanna to copy, ColumnBN contains criteria like type 1234.. I wanna copy rows in column A that corresponding rows in BN meet criteria such as B =1, in fact, I wanna to be able to copy cells in AW 4 times...

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

I don't have a very extensive background with excel, and no background with macros, but I have the feeling I will need to use a Macro to carry out the task in question.. I have two workbooks; one that serves as a database for all the materials my company ever uses, and another that servers as...

Hi, I'm trying to make a Macro to copy a column and insert it next to the last column pasted. This so I can add a new day to the data i.e. sales data for the first is in column c. Month totals are in column D. I want to copy the formula in column C and insert them into column D. The month total...

On sheet 1,in workbook1 cells A1:E1 have column headings, but no data. On sheet 1 of workbook2, the data range is A1: AC5000. I want to pick out the columns in this worksbook that match the headers on workbook1, copy and paste them under the column headers in workbook1. Can someone help me with...

Hi, I am a newbie here. I've been searching here, but can't find the exact thing. I know how to do macros somewhat but am a bit rusty with it and having a hard time. Basically, here is what I am trying to do. I hope someone here can help. I have a workbook with 250 columns, each column...