Adjacent cell not empty then copy above formula

[carlrubber]

I would like to do if adjacent cell not empty then copy above formula. For example, cell J5 J6 J7 not empty, then copy K4 formula to K5 K6 K7 once. Can anyone help. Thank you

[Special-K]

Not clear enough.

"J5 J6 J7 not empty"
What does that mean?
All of them have to be not empty or just one of them? Or something else?

[Glenn Kennedy]

Will you please attach a sample Excel workbook? Please don't attach a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[carlrubber]

Uploaded and thx in advance.

[carlrubber]

Please Login or Register  to view this content.

the code can copy formula in col J one cell from above if col I cell is not empty, but i want to be copy all cell with formula in col J from above if cell in col I not empty. thx in advance