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

fellodan

New Member
Joined
Mar 6, 2019
Messages
1
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:

ABCDEFGHIJ
Process smallP.Woods Not in
largeM.Twaitshol
mediumG.Rothery
5 StickN.Barhamsick
jmbC.Higgins
freshD.Opolski

<colgroup><col span="10"></colgroup><tbody>
</tbody>

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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top