loop and copy

Hi all. I hope the following makes sense and thanks in advance for your help. I have a spreadsheet in which the data is automatically updated every day on sheet 1. On sheet 2 column D from sheet 1 is copied across to sheet 2 into column B. Sheet 2 B2 =SHEET1!D1 Sheet 2, column C is a...

I am trying to write a macro with VBA that will copy the data from my table in a sheet tiled "Front End" to a table on another sheet called "Raw Data". here is my code so far for the copying and pasting into the other sheet in the next empty row. I keep getting error that says "application...

I just started learning the ropes to VBA and don't fully understand it yet. I am trying to create something that will change the value of two different cells, based on the contents of one cell. Specifically, if the text in column B says "shoecare", then the contents in column E need to change...

I have a workbook with multiple sheets. Each sheet has unique values in Column A that should match but all other columns are different among sheets. The code I have copies a unique list, and then filters the activesheet for that value. It then copies over the data into its own workbook, saves...

Hi all, What I am trying to do is copy any worksheets from one file (source) to another workbook (target) which don't already exist in the target file. Is there a way to loop through and compare each of the worksheet names and only copy the new ones while ignoring those that are already in the...

folks, trouble with inherited workbooks is that while the original macro author is around, things tend to have to be run their way. the workbook i am currently adding to is a consolidation of different financial systems. it ultimately creates the "one source of truth". The analyst that created...

Hello, I have multiple workbooks that I need to combine into one main master workbook. I have a macro already in place that opens/closes all the workbooks, I just need help looping through each open workbook and placing the data into my master sheet. See my progress below so far: My main...

Hi, I'm new with VBA but did quite a bit of macros last week with the help from this forum. Now I'm stuck with this one and can't figure it out. Any help is much appreciated. I have a schedule something like this on Sheet1: <tbody> Name Mon Tue Wed John Surrey 0900-1700 Van 1230-1945 APH...

Hi All, I am currently trying to Loop through a selected list of files, insert 2 rows at the top of each file then copying columns A to O out, then pasting those columns in A to O in a sheet called TK of my main work book, this sheet has a lot of complicated formulae in columns P to AV, and...

Hi, I am extremely new to macros and I am trying to create a macro that will copy paste a value from a spreadsheet called numbers.xlsm to a new spreadsheet called vlookup template.xlsm. In vlookup template.xlsm there are a series of vlookup functions. I want the value from numbers.xlsm to be...

I need help writing a macro loop that will copy data from a master file (always open) to all files in a folder (over 80 files in the folder). My current, inefficent method is to explictly state the file names and their location and the master file which is already open. Any help would be much...

hi there, I have one workbook with 50+ tabs and want to parse them out to a new workbook based on the specific cell "u2". Let's say out of 50+ tabs only 2 tabs have same number in cell "u2". I need the macro to pick these two tabs and copy to a new workbook. Here is the code I have so far...

Hi all Window 7 / excel 2010 Here comes my problem, I get workbooks full of data but not organised except for one thing the phone number is in the cell below the cell with the valuue "Phone" Currently I can retrieve each number in a sheet and create the list on the sheet 6. here is my code...

I am having an issue getting my value I copied to paste in to my autofilter. I have created a loop that will work down a list , copy the next value, past that value in an autofilter on a new sheet, copy the results found, and paste the section to the original sheet. The code will work down the...

Hey All I'm am trying to figure out a macro to run that: I want to insert a row after every change in cell value in column W and copy the Separated data into new sheets. Ex: Column w A A A A B B B B C C C C i want all the a separator between A,B,and C and all the corresponding data of A,b...

Here are the individual lines of code. How does one create a macro loop instead of all the lines of code: Range("D21").Select 'copy Subject Selection.Copy Range("E21:O21").Select Selection.PasteSpecial Paste:=xlPasteFormulas...

Hello! I'm trying to generate individual timecards for people based on data entered into a data range for a single week. I have a timecard worksheet that is filled with values from data on another sheet. I want to be able to create a copy of each persons' timecard and put them all into a new...

Hi All, I want to filter the range on Column D and want to copy those filtered data from column D to column A in same row i.e next visible cell value of columns D should be copied to column A. I tried to record a macro for same , but there i get the fixed value of range. Below is the code of...

Hello, I have no prior experience with VBA, but was asked to write a file that will combine data from multiple spreadsheets into one master sheet. Here is what I have so far: Sub OpenFile() Dim sPath As String Dim sFile As String Dim strName As String Dim FinalWB As Workbook...

Hi, I'm having trouble coming up with a way to create a code in VBA that would parse through a table of data, recognize if a value was in between a set of numbers and if it was, copy and paste the row into the next avaiable empty row in the new sheet. Then, if all went well, it would go down to...