copy column

Hey guys, I have three different worksheets. RawDataA RawDataB ReducedData Basically, I only want to take certain columns of data from each of the RawData sheets and comiple them together in the ReducedRawData worksheet. With what I currently have, I am running into issues copying over the...

Hi Team Looking for some help here.....I have Rawdata in sheet2 and column headers info in sheet1 (as mentioned below) ....in required columns data I need it in Sheet3 ....I need help in automating this process via vba.... I need formula to get the columns headers names in sheet1 based on...

Hello, Here is my code to filter Column E, and copy the Data in Column I. At the moment, I'm copying the header aswell. Can you tell me how I can copy the data in Column I without the heading? Code: Sub Financials_Pop_Emails() With Sheets("mySS Investor Details").Range("A1")...

I am using the code below, which works beautifully to insert the new column headings I need. Now, I am trying to come up with a way to look at the "N" columns inserted between column B and (former) column C as a result of the code (below)... and if this column heading also appears in row 13 of...

Hi All, I have a daily KPIs dashboard with consecutive days columns and KPIs as rows. The workbook is connected to a sql database and is refreshed on a daily basis. Once the refresh is completed I have to select the latest column (lets say yesterday) and copy right it to get all data for...

Hello, I am in a bit of a strange predicament, where the column headings on my system A generated report do not match the column headings that I NEED on my import sheet for system B. Also, the system A generated report has additional columns that I don't need. I have two worksheets... "2 -...

Hello, I would like to copy a specific column from sheet1 to the next open column in sheet2. So I would like to say take cell A1 and find that in row 1 of sheet1 and copy that specific column to sheet2. In addition it is copying a value with a formula behind it when I paste it I would like it...

I thought this: =IF(COLUMN(C$4:C14)<($J$2+2),C$4:C14 ,"") would work, but it doesn't seem to. Let me explain what I am trying to do: $J$2 is the number of participants and is a number the user will enter. Table Column C is data for participant 1 with all the drop down lists and everything set...

Hi guys, I Have got like hundreds of files. one example of the filename can be: test_A.xlsx that contains data in Column A I have also got a file with name: test_A_sv.xlsx that contains data in Column B How do I put the Column B from the file: Test_A_sv.xlsx in the file: test_a.xlsx in...

Is there a macro that can be written to If cell B2 is under 1.67, then copy entire column to new workbook, and email out to specified email recipients?

Hi, I recently posted a query but it was more like a project. I am solving one by one. I have already sorted column A to C based on column A values. Now I need to copy and paste column A in Sheet2. But in Sheet2 I want each row should contain only 10 values, the remaining values should go into...