vba & copy

Hi guys! My name is Eduard and I am fairly new to VBA. I have a hard time finding a way to create a form that allows me to send values from an entry point to a "so called database". What I need exactly is a code that will allow me to copy values from 2 cells to another 2 cells in another sheet...

Hello, I have an Excel table that I update with new information each month. When new data is added (new rows), using VBA I enter a vlookup into the new rows and the correct data is retrieved. However, when I select the new rows and try to overwrite the vlookup formulas with values (Paste...

Hi This may have already been asked so apologies if it has. I have a spreadsheet which i need copy column A, B and column AV from 3 sheets and paste these into a new worksheet. I need to try and set this to happen automatically. I think this will be a VBA before save (i think) is this...

Hello, I am looking to write a macro that is able to copy values in rows 3 to 10 if the word "copy" is in Row 1. For example, if Copy was in A1 it would copy A2:A10, but for all columns A through Z. Something along the lines of: If Range("A1").Value = "Copy" Then Range("A2:A7").Copy...

Hi Guys, Hope you can help. I need to know some VBA code so that I can count the number of rows on one sheet (not including header row ) then apply that number to a formatted range Part 1 Extract count. Sheet 1 is an extract of data and has a row count of 4 but I only need a round count...

Hi, I am fairly new to vba and I am trying to copy data from multiple sheets except from sheet names that are in the defaultsheetnames array. DefaultSheetNames = Array("Admin", "QBBOM", "Index", "Master", "Template", "Revision Log", "Instructions", "Sample", "Deleted Items", "ChangeLog"...

Hi all, as a newbie, I got a copy-paste problem using VBA. And here is the snapshot of my minimum working environment. At the end of each month, we will get data for column C and we were supposed to paste Column C data to the green area in order to get the total number. By using a little...

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