Macro to copy data from one cell to another if adjacent cell meets certain requirements?

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!

Maybe:

Please Login or Register  to view this content.

Thanks. The first part of the script worked to delete the unwanted rows so that was awesome!

The second part did not copy the data from Column H to column F, I'm not sure why not

Maybe:

Please Login or Register  to view this content.

For some reason the #'s are not copying to Column F from Column H. The rows are being deleted still which is a big help!

Can you attach a sample with some data too test on? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Wait - it works! It was my fault so I apologize. I did not realize this was case sensitive so Cost would not be recognized. I changed the case and it worked Perfectly! Thank you!

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

Welcome too the Forum SPHINIX. I'm glad you found it useful for your purposes. On the Forum appreciation is shown when click on the Add Reputation star at the bottom of the Post.