+ Reply to Thread
Results 1 to 3 of 3

Copy workbook to new workbook for one particular value.

  1. #1
    Registered User
    Join Date
    05-11-2020
    Location
    Edmonton, Alberta
    MS-Off Ver
    365
    Posts
    17

    Copy workbook to new workbook for one particular value.

    I have a work book that list all actives projects for our PM's in one work book. The work book contains some date that is extracted from the financial systems, as well as manually entered projects. We have multiple PM's and i would like to extract all data pertaining to the a particular PM into a separate work book. In addition I would like the formula's to copy with it as well.

    I have attached a copy of such a file.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Copy workbook to new workbook for one particular value.

    John

    No file attached/uploaded.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    05-11-2020
    Location
    Edmonton, Alberta
    MS-Off Ver
    365
    Posts
    17

    Re: Copy workbook to new workbook for one particular value.

    Sorry, I guess the original file was too large. Here is the reduced version

+ 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. [SOLVED] Copy data from selected sheet of multiple workbook & copy in master worksheet of workbook
    By sanjuss2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2021, 12:16 PM
  2. Replies: 3
    Last Post: 12-07-2017, 05:14 PM
  3. Assign name to Workbook, Copy range from one workbook to another workbook
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2015, 03:40 AM
  4. Copy data one workbook to another workbook without opening workbook
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 11:28 AM
  5. [SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names
    By Arsham24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:42 PM
  6. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  7. Replies: 1
    Last Post: 04-01-2006, 03:50 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