Can you transfer data from one Excel sheet to another using a ‘vlookup’ and have a function contained that will enter the data into the correct field?

Answer 1

Hello,

Yes, you sure can use Vlookup for transfer data from a sheet to another, keep in main you need to have a value in destination sheet that match with you data source, also you will need to create a formula for each column (field) you wanted to retrieve data from or use match function instead of indicate the column you want to retreive:

Using match function for get the right data into the right field automatically:

I did the example using 1 single sheet so that keep the example as simple as possible.

That not useful if your data structure change too often.

As a example, you number of columns in the data source change.

Instead of that try linking data from the source to the destination, it is the easy way to get a exact copy of a sheet into another Automatically (w/o using a macro):

It is useful when you want add formula to a dataset w/o edit the original data source.

There are multiple way to do this it depends on what do you finally want to do.

I would like to hear why you want to do that, then give you the perfect solucion.

CC