Hello guys. There is a file that is sent daily to me from other department but I don't like their format and template. I want to copy the whole content of their sheet and paste it to my RAW sheet, everyday and my template from other sheet will automatically generate the data from the raw. I understand that I need a constant spacing to make it consistent and continuously. I dont wanna have errors that is why I just want to copy paste their data and convert it to my own template. How do I make this please? I cannot make it work using Index Match with multiple criteria.
RAW
raw.PNG
My template
my template.PNG
Bookmarks