copy & paste using vba

Hi, I am new to VBA and am trying to write what is probably a relatively basic macro. I have one column labeled Data in the first row, with data in the rows following. I have another column labeled Data2 and I am simply trying to copy the data from the Data column (not including the "Data"...

Back again! I'm hoping that someone can help. I have a worksheet where I am copying the values that the user double clicks on and I want an input box (if that's the correct thing to use) to allow the USER to advise the named range to paste special the value to. Currently there are three named...

My setup: (2 Workbooks) Workbook 1 "Line Audit Workbook", Workbook 2 "Data" Workbook 1 has 2 worksheets - "1st Shift" and "2nd Shift" Workbook 2 has 1 worksheet - "Data". In workbook 1, both worksheets are set up identically with 13 columns. Each shift (1st Shift and 2nd Shift) gets information...

I'm a novice when it comes to VBA, and I have a list of names in Excel 2013 (Running Windows 8.1) and I want to write code that will generate and include all nicknames the person might have, so that if a user enters some variation - it will still be recognized. For example Richard would have...

I am new to VBA so all help is much appreciated. in sheet1, column AW contains values I wanna to copy, ColumnBN contains criteria like type 1234.. I wanna copy rows in column A that corresponding rows in BN meet criteria such as B =1, in fact, I wanna to be able to copy cells in AW 4 times...

Hello, I have a table of data where i want to select data that meet a certain criteria and copy and paste that to a table in another range. I.e. I have a table with 6 columns. The first column is date and that is what i am using as a condition. If the date for a given row is in the past week...

I have a Final workbook that needs to have information from many other workbooks. I had originally written a loop that opened a Source workbook, copied information, pasted as values in the Final workbook, closed out of the Source workbook, and went to the next Source workbook. When I run the...

Hi Everyone: I have been sorting through a problem, but cannot exactly figure out how to do it.. We need to be able to start a specific cell "F283" and move down through column F until there is a blank cell, and copy that column for use somewhere else. I have seen a couple offerings that are...

Hello mr excel world I need your help. I have to do a simple excel work. I want to creat a save button on Sheet1 (where i have boxes to write expecific things, and i want to pass to Sheet 2 in a right position. i can send images os the Sheets. Thanks a lot guys ;)

I am new to VBA and need your help. I have an Excel 2013 file (Name: Master Database) which have 3 sheets (Data 1, Data 2 & Data 3). I also have 5 different Excel files with same names (Data 1, Data 2, Data 3, Data 4 & Data 5) and all these files are saved in same folder (Folder path and name...

I'm trying to develop the code to run a macro on every sheet of the workbook, except for a few named sheets. The macro is simply copying the information from each worksheet into a list on the "Summary" sheet. I am very new to VBA (as you can see from my macro below). Here is what I have so far...

Hi, I am not a vba expert and have been looking for vba codes online to help with merging multiple sheets into a single sheet. Basically, I have multiple sheets that I have already filtered out for blanks in Column B. I would like to transfer that data of each spreadsheet (Column A-G, from...

Hi Hoping you guys can help with the below. So what the code is doing is it is searching for 'Global Name' in Col M and then moves down a row to where the formula's are stored. I then want to copy the formula's down for the number of rows in Col L. I can't find the right code to do as it is...

Hi, Let me start by saying I am not familiar with VBA but I do know these codes can be very powerful. Any help that you could provide would be greatly appreciated as I am really struggling with this process every month. I maintain a huge 2007 excel workbook (called Main_Model) that reflects...

Hi - i currently have a piece of code that will copy the selected row and paste it right underneath. However, whenever I filter on a column and run the macro it will copy but paste blanks. There are some vlookups in some of the columns so was wondering if its possible to copy and paste exactly...

Hi! I desperately need your help! I am very new to VBA, but need this code urgently... I have a workbook with 2 sheets, one is a list of deliveries with 10 columns and endless number of rows (Sheet1) , which is filled by the company, and another with 23 columns and even more rows than in the...

I'm an advanced user of Excel yet have a minimal understanding of vba coding. I have looked through the forum and can only find vba coding related to inserting copied rows into new worksheets as opposed to inserting them into the same worksheet. I need some vba code to allow the contents of a...

Hi, I want to create add sheets copying some columns from a "master" sheet using the range command. I am having an issue with a Error 1004 "Application-defined or Object-defined error" when selecting a range using a cell format. I would like to use cells so I coud have the columns in a...

Hi All, I have a code which is assigned to a button, when the button is pressed the below macro runs and selects and copies all information which has a figure in column H and pastes it into a new work sheet "ORDER REC" I was wondering if there is a way of deleting all the information in...

Hi all! How do I copy-paste range A1:L16, every time, until row 500? Can you help me build a simple VBA/Macro? Thanks.