Results 1 to 3 of 3

MAcro to copy specific data in other workbook, but name of the workbook will change

Threaded View

etunam MAcro to copy specific data... 04-15-2013, 07:17 AM
Norie Re: MAcro to copy specific... 04-15-2013, 07:22 AM
etunam Re: MAcro to copy specific... 04-15-2013, 09:06 AM
  1. #1
    Registered User
    Join Date
    04-14-2013
    Location
    Madrid
    MS-Off Ver
    Excel 2010
    Posts
    2

    MAcro to copy specific data in other workbook, but name of the workbook will change

    Hello, I am trying to biuld a macro to filter and copy data to some colums in other workbook, but I will do it for several workbooks:
    The source workbook is located in the same folder than destination book (I made a lot of folders with all the workbooks) and source workbook has a long name containing the word "woll", the worksheet will be the same for all the source book (Woll Basic) ant the column the same V, begining from V2.


    I made this macro to resolve the problem of the relative path:
    Dim wbSource            As Workbook 'workbook where the data is to to copied
       Dim wbFin               As Workbook 'workbook where the data is to to copied
       Dim wbThis              As Workbook 'workbook from where the data is be pasted
       Dim ThePath             As String   'name of the source sheet/ source workbook
       Dim TheFile             As String
    
     ThePath = ActiveWorkbook.Path
       TheFile = Dir(ThePath & "\" & "*well" & "*.xl*")
       Set wbSource = Workbooks.Open(ThePath & "\" & TheFile)


    The destination workbook will be always named Planti, and the worksheet "Wills"

    What I am trying to do, without any good result, is filter column V to find any cell with "wild" or "explo" in the text and copy it to column A in Planti, together with the corresponding value of W and AA, that will be pasted in columns E and C.

    I am begining with the macros but is too dificult for me...

    If I have this I can try to do the next step, sort the data in another columnwith the value of column AA (paste in C)

    Thanks a lot!!!
    Last edited by etunam; 04-15-2013 at 07:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1