Macro to add certain cells to another worksheet based on cell $

Closed
mindspincycle
Posts
1
Registration date
Wednesday June 25, 2014
Status
Member
Last seen
June 25, 2014
- Jun 25, 2014 at 02:39 PM
Sorry, I know this has been covered a million times, I've looked up probably 30 different examples that look very similar to my situation for a macro, but haven't been able to make it work. I've changed their codes where it looked like it needed to be changed, but nothing happens :/


What I'm trying to do is:
When any of the first five sheets have a value of >1 in cell "J", I'm trying to copy certain cells from the same row ("A-G" and "J-L") onto the next available row in a sheet called "Payments".

ALSO:
What I'm trying to do is:
When there is text in Column "K", I'd like to add rows "J" & "K" from the same row onto the next available row in a completely different workbook.

I have been right clicking a sheet name, going to "view code", then pasting the code and modifying it in the blank box. Then to test it, I close visual basic, click on the "developer" tab, then the Macro button, and click "run" for the macro I've just created. Is this the correct way of going about it? Thanks for any help. I'm so confused on how to make this work!