+ Reply to Thread
Results 1 to 4 of 4

Copy specifc cells from adjacent Workbook

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Copy specifc cells from adjacent Workbook

    Hello everybody

    I have two workbooks (Customers and Bills)
    In WB named Customers I have the following code that copy specific cells from first sheet only in WB Bills
    I want to loop in all sheets not only one sheet and copy the data from these specific cells

    Another point as for Type column it should be the letters before the backet (
    say sheet name in Bills Workbook named INV.(12311) >> in Type column I have to get the letters before the first bracket (

    As for Column Curr. I want to search for the string (Total Invoice) in the sheet and to use offset to get the string (EGP) for example..

    And depending on Curr. column the value in the row (Net Due) to be copied in proper column .. as in my example to be put in column EGP

    I hope it is clear
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: Copy specifc cells from adjacent Workbook

    We caan start by using loop at first .. Step by step if it is difficult But I know it is very easy with professionals

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: Copy specifc cells from adjacent Workbook

    After many tries I could loop through the sheets
    Please Login or Register  to view this content.
    But I still need it to be complete

    In Type column it should be the letters before the backet (
    say sheet name in Bills Workbook named INV.(12311) >> in Type column I have to get the letters before the first bracket (

    As for Column Curr. I want to search for the string (Total Invoice) in the sheet and to use offset to get the string (EGP) for example..

    And depending on Curr. column the value in the row (Net Due) to be copied in proper column .. as in my example to be put in column EGP

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: Copy specifc cells from adjacent Workbook

    Now I solved that part of Column Type by this line
    Please Login or Register  to view this content.
    Help me with the rest... Just last point :
    As for Column Curr. I want to search for the string (Total Invoice) in the sheet and to use offset to get the string (EGP) for example..

    And depending on Curr. column the value in the row (Net Due) to be copied in proper column .. as in my example to be put in column EGP

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to copy non adjacent cells to external workbook and move down row
    By excitingexel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2016, 08:15 AM
  2. Replies: 3
    Last Post: 03-26-2013, 06:06 PM
  3. Search for a value in closed workbook and paste adjacent cells to open workbook
    By jmapark91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2013, 10:54 AM
  4. Macro to copy non adjacent cells to external workbook and move down row
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-06-2010, 04:55 PM
  5. Replies: 6
    Last Post: 03-16-2009, 05:05 PM

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