loop and copy

  1. D

    Copy Data to New Workbooks

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

    Excel 2007 VBA to copy sheet to another file if the sheet doesn't already exist

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

    code condensation assistance required

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

    Copy/combine data from multiple workbooks

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

    Copy Paste in another worksheet based on cell value vba

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

    Excel 2010 Visual Basic Code for looping through files copying required data and then copying results of formulae

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

    Copy Paste Loop

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

    Macro loop to copy data from master file to all files in folder

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

    copy multiple sheets to a new workbook based on specific cell (VBA)

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

    Multiple loop inside one another

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

    Creating a Loop and pasting alternating values into an auto filter

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

    Macro to insert a row after every change in value and copying the data into new sheets

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

    Copy 1 cell to a range of cells and loop every 3 rows

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

    Trouble Looping through list to generate individual timecards

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

    How to execute loop only on the filtered range

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

    Merging Spreadsheets

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

    VBA If Functions and Copying Rows over to new sheets

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

    VBA If Functions and Copying Rows over to new sheets

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

    Loop through entire sheet in VBA

    Hello! I've been stuck on this one task for a while now and I was hoping to get some help. I currently have a spreadsheet of data ranging from A1:AF60, some of which are in BOLD text. I need to loop through each cell in the entire spreadsheet and select the entire row if that row contains a...
  20. N

    Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

    Hello, After spending too much time on this problem, I am hoping to find some help here - seems like the right place. This is the last bit of code out of a larger macro - which (except for this bit) works fine. I have one dynamically changing column - i.e. a column within which Solver loops...

Some videos you may like

This Week's Hot Topics

Top