Results 1 to 2 of 2

Thread: Copying data from one workbook into another workbook based on specific data in the first workbook
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Copying data from one workbook into another workbook based on specific data in the first workbook

    Hi
    I have a worksheet tracking sales reviews. I want to copy specific cells from that worksheet to a sheet in another workbook depending on whether or not a given cell in the first worksheet contains the letter Y. The first worksheet will be looked at by me every Monday and I would like any new rows of data in that copied across if the given cell contains Y, and any cells that have already been copied across to be updated (i.e. copied again) if additional text has been added since the data was last copied. I don't know VBA and have limited macro writing skills and would really appreciate any help that can be given.
    I hope I have explained my problem and need clearly!
    Kindest
    Kim

  2. #2
    New Member
    Join Date
    Apr 2019
    Location
    Porto - Portugal
    Posts
    16
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copying data from one workbook into another workbook based on specific data in the first workbook

    An example would be great, at least for me...
    However, instead for searching for updates, can you copy all over again? In other words, every time you run the code, you are going to copy all cells with Y, even if that were copyed earlier or not. But on the other sheet you have to delete before importing the new data. Am I making myself clear?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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