Apply filter and cell reference
 

Hi There,

I"m having trouble trying find the right coding:

This what i want to accomplish

1) apply a filter on column d to equal Maintenance

2) in Column J row 5 = Cell reference the result in Column I (Ie I 5) (Row
number could be different each month) ie = J5 would the formula in that row


3) copy the formula in Column I row 5 to All the rows available on Filter
data
Each time the rows will different each month.

4) take the clear all the filter but don't take off the filter

When the filter is cleared:

In column D = maintenance then amount is column I

If it doesn't equal maintenance then nothing is in column I

I hope someone can help.

thanks
keith

Apply filter and cell reference
 

Hi everyone,

Is there anyone that can help me?

"umpire_43" wrote:

Hi There,

I"m having trouble trying find the right coding:

This what i want to accomplish

1) apply a filter on column d to equal Maintenance

2) in Column J row 5 = Cell reference the result in Column I (Ie I 5) (Row
number could be different each month) ie = J5 would the formula in that row


3) copy the formula in Column I row 5 to All the rows available on Filter
data
Each time the rows will different each month.

4) take the clear all the filter but don't take off the filter

When the filter is cleared:

In column D = maintenance then amount is column I

If it doesn't equal maintenance then nothing is in column I

I hope someone can help.

thanks
keith