Ok I need excel to do one or two things, to accomplish my goal.



I either need to make it do this:
If column A in worksheet one corresponds with Column E in worksheet two, withing the same workbook, I need D,E,F,G of worksheet one to paste into D,E,F,G of worksheet two... Is there anyway to do that... I am new to excel sort of... At least this part...


Or...

I need it so I can use the find tool and find/replace multiple items at once but replace them all with the same thing. What would I use in the find box to seperate different things for it to find... I tried commas and colons...