VBA to Paste cells acording to list of cell references

Hi Guys - Hope you are well.

I have some VBA that I would like some help to write - I'm not really sure where to start.

I would like to paste cells from a contiguous range to a non-contiguous range using a list of cell references as the target paste cells. Both the target and the source cells will be on the same sheet. The source cells will contain an INDEX/MATCH formula - the result in each cell is what I wish to copy then paste. I would like to activate the code by assigning the macro to a button.

The source columns look roughly like this:

Title	Index/match result	Cell reference to paste to
Text 1	23	B5
Text 2	Peter	H7
Text 3	Continuous	D11
Text 4	[BLANK]	F7
Text 5	Membrane	J12
.......	.......	.......
Text 57	Yes	K33

The Target columns are all over, as shown by column three above. I would like the code to run though the full list of index match results all the way to the last 'Text 57' - the code can either skip blanks or paste these also, I don't mind. I haven't written the INDEX/MATCH yet so it may return zeros if there is no data to pull.

I attach the full example here.
Entry Form EG.xlsx
I really appreciate your help.

Hi Alan,

Thanks for your reply.

Yes normally this is what i would do, however I use the worksheet as a form that users can enter data into. What I am trying to achieve is to be able to to populate the form with the info existing in the database so they can see what is there and either overwrite it or leave it if they think it is more current than what they have. Once they have edited all or some of the cells I have a button they can click to copy the combined or new data back to the database.

I thought I might be able to save 57 lines of code by having the cell reference in a list that VBA could use rather than having to put in the actual cell reference in the code.

Do you think this is possible?

Thanks again.

Thanks Alan for putting the call out - much appreciated.

Thanks so much TMS - just off to the land of nod - I will run the code in the morning.

Thanks for your help Sixth Sense - I will test it tomorrow. Just off to bed!

Hi Trevor,

Thanks for your continued help.

I was quite amazed at how little code there was - "All hail Trevor"

There is one small hiccup that hopefully shouldn't be too difficult to fix. The code currently copies the formula in the index/match column and the formatting - is it possible to just have the values pasted over such as happens when one does the "past special>paste values"?

Thanks again for your help.

Zac

Hi Trevor - that fixed it!

Thanks for your generous help.