Compare data and copy specific cells

  • Hi there!


    I'm a newbie here seeking for help!


    I have different sheets per category that needs to update daily, and I have a unique identifier on each sheets. The data that needs to be update is under UPDATE sheet, am trying to update the specific range ( I to V) data on my update sheet to their respective sheets. sample.xlsx



    Any ideas of how to quickly and efficiently accomplish this task?


    Thanks for any help.

  • royUK yes, I do understand that it would be easier but i have a huge data that are separated into different categories, and also the identifier are on the same column for all sheets..


    I hope you can help me ?

  • Hi there!


    I found a this code and it copies the entire row but what I want is to copy a specific range only.


    Can anyone help me with this code..


  • There are several options available to work with data and it's easier to maintain if it on one sheet.


    Also, when posting code use Code Tags not Quote Tags

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!