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