Hi,
I'm new to the forum and a pretty basic excel user. I did some searches and tried a few of the scripts I saw but was unable to get them to do what I need.
Basically I have three columns in a work Sheet F, G, & H. F is empty, G contains text and column H has both text and numbers.
I want to be able to automatically copy the value from Cell H to Cell F if cell G contains the word cost.
Thanks in advance!
As a bonus question I would also like to delete all rows where Column G & H contain two dashes --
Thanks!
Bookmarks