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