vba & copy

Hi Guys Could you please assist me I have a master workbook that needs to be copied 500 times with different file names based on a list. I have used the following code Sub CopyAndRenameFiles_3() ' Define variables Dim MasterFilePath As String Dim NewFilePath As String Dim...

Hi my I want my code to copy and paste the column of data, to the next empty row in the stated sheet. It is currently copying the data to the row in the correct sheet, but doing 34 times. Can someone please help advise where I am going wrong? Sub CopyData() Application.ScreenUpdating...

Greetings and good time dear teachers: In an Excel file that has entered a series of specifications and also has a row, if we want to enter a specific and fixed cell, when we enter the row number, that desired row will be deleted and also pasted in another sheet, of course with VBA. What...

I am trying to Copy data from one document to another. I have a userform that allows for you to select which sheet you want to copy from and to. I also have to where it will paste into the next empty cell in the line. I have tried paste to a single cell reference and i have tried selecting the...

Hi Everyone! This is my first post and I just have one question Let's say that we have two separate sheets, the first one, witha table of information for each teammate, like this one ID Name Last Name 1 A D 2 B E 3 C E And another sheet (let's call it "List" the one we want to copy...

Hello Gurus, Hope all is well. I have two tabs namely Excel 1 and Excel 2. Excel 1 contains the data and I need to filter it to Copy+Paste in the Excel 2 tab based on the following criteria. Copy and paste whole row if contains these: 1. Column B = Look for "Math" 2. Column C = Look for "UK"...

Hello everyone, I got helped before with a macro that copies amounts from 1 excel file to another excel file based on the names that are in the B column. It also makes the B column red if it didn't find anything to copy it to. Now I need to add a couple more things to this macro so I wanted to...

Hi, I am a complete novice to vba and looking for help here. I need to copy data from a specific column 'Name' on multiple sheets in to one sheet based on criteria - The criteria is - Filter on column 'Contractor' as No find column which has column name containing current month Check the...

VBA: Color all emails if any in cells of column A to green. I have thousands of rows with emails in the cells of column A. How can I force color all emails in green and copy them into respective rows of column B?

Hello Everyone, I am trying to automate the copy and paste proces. The things that need to be copied is the amount of times a product is sold. And the way I can find these products is by the code that they are assigned. All products that aren't sold won't show up in the file so I also need to...

Hi all. Im Just having some trouble with the below VBA, works the first time perfectly but every second time it crashes and comes up with run time error 1004 PasteSpecial method of range class failed. Also, I'm looking to add to this macro an email alert with just text only, Any help would be...

I'm new to VBA and I'm trying to create a script that allows be to put a selected group of Excel files in a folder and do the following: 1) A pop up window to ask me which folder the files are in 2) Select all the files in the folder 3) Open each Excel file one by one 4) Upon opening the Excel...

I am trying to make an excel file for my parents so that they have it easier than writing all the info in a book X amount of times. i have A; B; C; D; E; F; G; H; I; J; and L columns and want to automate and duplicate the data in A to G in rows below xn-1 times when there is a number on Hx...

I have been searching a solution and cannot seem to find one, is this possible, What I am trying to do is write a macro that will create a pivot table onto another tab. The sheet that the data is on is titled with a customer reference number which changes from workbook to workbook. Is it...

I have a worksheet that I need to copy cells in row 7 but I only the information from every 7th column for now. For example, the first few cells I need to copy are C7.J7,Q7. This file goes on for years worth of data. I tried =OFFSET(C7,0,7) which worked for the following cell but when I drag it...

Hello, I have an inventory of equipment, radios, and vehicles that is updated by many users. This update is sent either in total or in part to a fleet manager for insurance purposes. I have set up a user form for the department heads to use when an update is required. The user form allows the...

Hi, following request I had done before with the FormulaLocal(sverweis). Now I want to learn more about if loops, but I cant get it done. So I ask you for help to show me how to do it. Request - Reference worksheet uploaded: check if value in blue marked column of worksheet "Bezugsdaten"...

Hello folks, I am desperate to scan the tables via Vba and determine specific values. I have a master table (first table) that is automatically generated in a sheet every day. This table should be compared with the table on the left (here as an example below) and the data from the master...

Hello, I am looking to figure out this VBA code I am trying to write for a project I am working on, I have it that it will search for a certain text in column L, once it finds that certain word I want it to copy and paste columns A-K down from the row that it found the certain word until a...

Hello, I'm looking for some help on VBA. The code is to create a file to import into QuickBooks for invoices. I have some code i've written that takes a pivottable and copies it to a new tab. Pastes it as values and insets a blank line. I would like to add another line that is the "SPL" that...