Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mp90
  • Order by date
  1. mp90

    Excel macro loop: copy and pasting rows into seperate file

    Our data is not tabular unfortunately, so I don't think MS Query will work. Is there anyway to edit the code above to run through the 10 files (if I have the folder open) and copy it along the rows of the master file?
  2. mp90

    Excel macro loop: copy and pasting rows into seperate file

    I have not tried yet; I do not know much about VBA. I do have this code: Sub test2() Dim wb As Workbook, wbFR As Workbook Dim wsFR As Worksheet, wsTO As Worksheet Set wbFR = ActiveWorkbook Set wsFR = wbFR.ActiveSheet MsgBox wbFR.Name & wsFR.Name For counter = 2 To 115 'rows between top an...
  3. mp90

    Excel macro loop: copy and pasting rows into seperate file

    Hi, **Disclaimer: I know NOTHING about programming in VBA** I have a large set of data that I need to take rows of data and copy and paste it into one large master excel worksheet. The easiest way to understand this is by an example (I think): 1. Path to the files that I need to copy from...

Part and Inventory Search

Back
Top