Hi All. Fairly new to the world of VBA. i'll give a brief description first and then add more detail. I'm basically wanting to search down a column for specific words, each time I hit one of these words I want to jump into the previous column and cut the value from there and paste it as a value to the first available blank cell in a set range. so here is what i've got in terms of spreadsheet: A B C D E F G H I J Process small P.Woods Not in large M.Twaits hol medium G.Rothery 5 Stick N.Barham sick jmb C.Higgins fresh D.Opolski so I want to look down column E, when I either see sick or hol I want to copy or cut the name at the side and then paste it to the first available blank in column H as a value. Any help would be much appreciated. Regards

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel VBA. Copy and paste from one cell to another based on value.

Thread starter fellodan
Start date Mar 6, 2019
Tags

column loop and copy paste value paste vba

fellodan

New Member

Mar 6, 2019

Hi All.

Fairly new to the world of VBA. i'll give a brief description first and then add more detail.

I'm basically wanting to search down a column for specific words, each time I hit one of these words I want to jump into the previous column and cut the value from there and paste it as a value to the first available blank cell in a set range.

so here is what i've got in terms of spreadsheet:

A	B	C	D	E	F	G	H	I	J
Process		small	P.Woods			Not in
	large	M.Twaits	hol
	medium	G.Rothery
	5 Stick	N.Barham	sick
	jmb	C.Higgins
	fresh	D.Opolski

so I want to look down column E, when I either see sick or hol I want to copy or cut the name at the side and then paste it to the first available blank in column H as a value.

Any help would be much appreciated.

Regards