copy columns

Hello, I am trying to tell VBA to copy all the rows that contain the name 'Chris' to a sheet called 'Chris' and then Rob, Andrew etc. But I want it to just copy from Column A to K. At the moment it's working but with the entire row. Is there a way to change this to just go up to column K...

Hi, I have the following code that copies filtered data from one sheet to another. I use the copied data to populate a listbox on a userform: With ws .AutoFilterMode = False Set rng = ws.Range("B8:R8" & .Cells(Rows.Count, "B").End(xlUp).row) rng.Copy...

Good morning all, I have around 30 worksheets (all in the same workbook but not all the sheets in the said workbook) that I need to copy 1 column range (C11:C90) in each of these tabs into a new file (ProdData.xlsm) Sheet "Qtr" at "C11" and then the next subsequent column ("D11, E11" etc.) I...

I'm not even sure where to begin with this but here is what I was asked to do: <tbody> "When a date is entered in column F(Contract Award/NTP Date) and the "Execution/Monitoring in Construction" is selected from the drop down list in column D(Project Lifecycle Phase), the Column...

in sheet1, I have a column A, where it contains several groups of data (in number format), and each group start with a cell that has this Group's name (text), I wanna to be able to copy groups (including group name and data) based on desirable group names. Each group has different number of...

Hi. I need to copy values in a column. Which column varies, but the title of the column (in row 1) is always the same. I had: Dim Constant Constant = Range("C:C") The problem is that the values I want may or may not be in column C. The column I want to copy has the text "Resource" in row...

Hi I need to copy and paste the values of certain columns from one workbook to different columns in another workbook. See my code below.. I know this code is not efficient, I am new to VBA and would appreciate any help to make my macro more efficient.. I could start copying from row 2 instead...

Totally stuck with a macro which I thought would be easy at first.. but have tried lots of different ways code and Googling to find similar solved problem but not getting very far.. so any help appreciated,,, All I am trying do is just copy all the data in one column (Col K) to another column...

Hello everyone. :) I need your help in building a macro that would allows me to copy specific colums from one workbook to another workbook. The first worksheet consists of Column A until Column DJ. A lots, rite. :stickouttounge: Of all of these columns, I just want to copy Column C, D, &...

I'm pretty new to VBA and I'm trying to automate a few things and the task at hand is like this: Two sheets in my workbook 'marketing.xlsm' -Sheet1 and Sheet2. Sheet1 is the source sheet containing between 5 and 15 columns at different instances (import different CSV files weekly) but they will...

Hello all, I am working on a project where I am bringing data in from different sources, manipulating them into one sheet. One problem that I am encoutering, that I cannot seem to wrap my head around, is selecting a group of cells and pasting them to a specific field in another sheet. The...

I have the following macro which is taking data from one range of cells & copying it to the next free column in another worksheet (starting from row 14). Sub CopyColumnBandPasteToFirstFreeColumnSheet2() Dim PasteToCol As Long PasteToCol = Sheet5.Cells(14...

Hi Everyone I'm new here, and excited to join the community thanks! I need some help on a VBscript / Macro I was trying to make. Rep Name is Column J Row 5. I need to find multiple columns based by the header which is row 5, if column range (j5:az5) is “Video – Actual” then copy column to sheet...

HI, I have to copy one column from 3 different sheets to one sheet. Details are: Copy from: DATA(Column B), SCREEN(Column B), SUMMARY(Column C) sheets Copy to: LABELS(Column B) I dont know how many cells will be there in those 3 sheets. Plz reply.

Hello. I download several spreadsheets monthly that have a large number of columns (A to EZ). In every excel spreadsheet I need to copy only 18 different columns of data from the sheet which are the same columns each month, and put them into a new spreadsheet. It is very time consuming to...

Hello. I have been googling for a long time to find a simple answer to what I believe to be a simple question...no luck, so thought would try here. Every month I have to download about 30 spreadsheets with several columns of info. I only need a few of the columns, so I need to copy 18 of them...