Results 1 to 9 of 9

getting data from one work book sheet to another

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-14-2007
    Location
    London
    MS-Off Ver
    office 365
    Posts
    118

    getting data from one work book sheet to another

    Hi all hope you are all well. If you can help with this it would save me a lot of time

    So I have 2 workbooks with sheets

    workbook 1 is - Startup Loan Tracker
    workbook 2 is - Outset Finance - Outcome of Loan Applications

    In workbook 1 for the sheet Leads i have a column AC - Loan Status here we have various statuses but the one i want to test for is Loan Submitted and if this is the case then information in that record is copied to the workbook 2

    Outset Finance - Outcome of Loan Applications

    Namely

    Column B,C,E - Name , Email, Business Name

    See attached samples


    So the process is

    In Workbook 1 - column AC (Loan Status) is updated with Loan Submitted - this then copies Client Name, Client Email and Client Business Name in to work book 2 sheet

    Hope you can help
    thank you

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Have Data that is caled from another work Book Permanate in the newly created Book
    By TBM in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-26-2019, 01:39 AM
  2. [SOLVED] User Form to write to a second work sheet with in the work book
    By mmikem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2019, 06:19 PM
  3. [SOLVED] Retrieve data from closed work book and match with active sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2017, 02:55 PM
  4. Current work book .xlsm convert to xlsx work book then mail
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-26-2016, 09:47 AM
  5. [SOLVED] copy work sheet from another work book into already exits sheet
    By Baskar5353 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2015, 03:18 AM
  6. Replies: 8
    Last Post: 05-21-2013, 10:07 AM
  7. How to extract a particular data from Multiple work book and save it to single sheet/
    By Swapnanjali in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 05:17 AM

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