Excel Formula
Budget: $10 – $30 USD
I need an excel formula that can help me automatically pull values from one sheet to another.
I have a template where I normally need to pull data from another sheet. I don’t want to use vlook up every time I need to pull data. I want to be able to paste the source sheet somewhere and then it automatically pulls the data into the template.
Note that the template and the sheet don’t always have the same column arrangement. Sometimes there are additional columns in the source sheet and not arranged the same way. See the attachment for an idea
I have a template where I normally need to pull data from another sheet. I don’t want to use vlook up every time I need to pull data. I want to be able to paste the source sheet somewhere and then it automatically pulls the data into the template.
Note that the template and the sheet don’t always have the same column arrangement. Sometimes there are additional columns in the source sheet and not arranged the same way. See the attachment for an idea