copy & paste columns

I'm VERY new to VBA and have exhausted much searching online to find VBA that matches exacly what I am trying to achieve. I have an "Ordering" sheet and a "Validation" sheet. I want to be able to copy and paste data from Ordering to Validation (next available/empty row) only if the dropdown...

Hi I have an input column with the date of input at the top and number values on each row of that column (30 no.). I then have a table of weekly dates horizontally in another section of the worksheet. What I need is to copy the data from the input column and paste the values into the...

Hi Excel Gurus, I'm working on an macro project and almost done. I'm just having a problem on this: I have 2 excel sheet, one is working file and the other is database. What the macro needs to do is to check the cell with blank category (in working file) and add below column data in the...

Hey everyone, this is my first post here since I'm new to VBA. I'm not good at coding but I will provide you with all the information I have right now. Summary: My goal --> Macro Step 2: Trying to create a macro to consolidate data from multiple workbooks / Suppliers into one Master-File...

Greetings. I am having trouble being able to copy the last two columns with data in a worksheet and then insert the same columns to the right of them. Here is my code so far, it does not work because the top row is merge of more columns. Here is the is the screenshot link. Sub newTest()...

Hello Excel Gurus, I was thinking of creating a macro based on below criteria: 5 Tabs will be created in running the macro: 1. New - New accounts that doesn't have any previous data (Copy Whole row) 2. Zero - Accounts that doesn't have any score currently but previously existing (Copy Whole...

Hello there !!!! I am new to excel and trying to do a pretty big project and I cannot figure out how to solve an error that keeps popping up. I have a weekly schedule which has 7 columns, each one for a day of the week. I am now trying to do a daily schedule which copies all the values from the...

Hi Team, I am looking for some help in copy and paste the data based on some criteria. For example, I have 175 columns in sheet2 and this might increase or decrease. I have 25 columns in sheet1 this may increase or decrease based on the requirement and all these columns has the same names (99%...

Hi... I have data in column(A) which get updated after a minute. Values in this column(A) are derived values. What I want is , that data from column (A) will get copied to column(B) after minute and after 2 min, updated value in column(A) should get copied in column(C) and so forth. I have...

Hi I am searching for a VBA that will perform to copy the last cell data in a column "A" and paste the same above all the cells in that same column "A" in that same worksheet. Kindly help. I have provided a format here. I need to do this operation for 100 + files . So kindly provide some...

I have the following code where I am selecting a range from excel, opening a word document, then pasting it to that word document. However, the code does not copy and paste the data, and I am not sure why. Please let me know your thoughts. Thanks!! Sub Report() Dim wdApp As...

Hi, Below is a simplified example of tables I have. the 1st tab is in one sheet and the 2nd one is in a different sheet. Basically what I wont to do is to write a VBA code to copy & paste the value shown in tab 1 to tab 2 in the 2nd sheet if one codition is met, which is the date. In other...

I need help modifying a macro. I have three separate files. These files are called "Dublin Sales", "Client Sales Tracking" and "Omnibus". I am trying to grab specific columns from the Omnibus and Client Sales Tracking files and copying the data over to the matching columns into the Dublin Sales...

Hi There, I need help building a macro that copies entire columns from one workbook over to another based on matching column names in row 1. These copied columns would then need pasted in another workbook based on the matching column names. Another way of saying this is to use macros to do a...

Hi all, I have been going through all of the possible answers in Mr Excel and none of them seems to fit my specific problem. I would just like to have a scenario like this: 1 2 3 4 5 This must be copied horizontally n times. Thus lets say A1 = 5, then the output must be: 1 1 1 1 1 2 2 2 2 2...

I have three sheets Sheet1 , Sheet2, Sheet3. I would like to create a VBA to do the following: 1. sheet1 A1 is populated with a date. 2. I would like to take Sheet1 A1 and find it on Sheet2 in range B1:O1. Once found copy that column down to last value. 3. Paste the above copied column to...

Hi all, I have been searching for a macro for a while now to cleanup a file that has many columns. I have five columns that are named in row 1. I want to grab only these five columns and move to a new workbook. The only catch is that this file sometimes changes and gets additional columns added...

I need help trying to figure out how to copy and paste certain columns from one row and pasting them into a separate workbook row. It is a total of 24 columns, but they are not necessarily in order. I would also like the data to be pasted as text, if possible. I am very comfortable in Excel...

Hi, Can someone please help? As the titles says, I'm trying to copy columns from one sheet to a specific cell in another sheet. It works for the first one, but when it gets to the second I get the error "Copy method of range class failed". I searched in other threads for the same error but...

Hi, I wonder whether someone could help me please. I'm using the code below to find a cell value and then copy and paste into "Sheet 1". Dim Src As Worksheet, Dst As Worksheet Dim LastRow As Long, r As Range Dim CopyRange As Range 'Change these to the correct sheet names Set Src =...