Excel VBA To Refresh Data From Different Sheet
Results 1 to 4 of 4

Thread: Excel VBA To Refresh Data From Different Sheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2017
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel VBA To Refresh Data From Different Sheet

    I have an excel workbook with a worksheet called Active and a worksheet called Webcycle. Each row is a unique entry. I have columns B:P I want to have it refresh all the fields from each cell by doing a VLOOKUP on value in Cell B to worksheet Webcycle and if there isn't a value from Cell B to match then copy the row into Active sheet. So to explain more in the sheet called Webcycle I will have either NEW data I would like to be copied to Active Sheet or data I would like to refresh on Active Sheet. Formatting between the two sheets are the exact same as far as headers and stuff. Cell B would have the Document Number I would like to use to determine if its going to refresh the data from Sheet Webcycle or copy the data to Active Sheet. If its copying new data from Webcycle Sheet to Active Sheet then copy the new data at the bottom after the last row. If its refreshing the data then just copy it over the existing cells.

    I'm hoping someone can help me and give me a code to make that happen. Let me know if you have any additional questions. I would greatly appreciate the assistance.

  2. #2
    New Member
    Join Date
    Aug 2017
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel VBA To Refresh Data From Different Sheet

    Anyone???

  3. #3
    New Member
    Join Date
    Aug 2017
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel VBA To Refresh Data From Different Sheet

    I am still looking for someone to give me some assistance with this...

  4. #4
    New Member
    Join Date
    Aug 2017
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel VBA To Refresh Data From Different Sheet

    Please......someone.....lol.

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
  •