vba, macro, shift down after autofilter

[mawar5530]

Hi Friends,

I am new to vba, really need help to find solution.
After autofilter the selction of "Poitem" example, i want to change G coloumn number beloging to "Poitem" to "zero" value
i dont find any way to offset, because the range keep on changing acording to report, so the offset not working for me.

 

[mawar5530]

You're welcome

But now another problem.
The formula not calculate the current cell instead.
its should be "=IF(F24=0, ABS(F24-G24),F24-G24)"

 

[MARK858]

The formula in the code line that I posted would not have produced the formula that you show in your image.

 

[mawar5530]

The formula in the macro would not have produced the formula that you show in your image.

Do you means by the calculation or the code ?

Just want the formula according to cell filter feild
How about if = F24-G24,

 

[MARK858]

The formula in the code was

.Formula = "=IF(F2=0, ABS(F2-G2),F2-G2)"

it cannot produce =ABS(F2-G2).
It is not possible, you have altered something.
Even if you had the column formatted as text before the code ran the nearest any cell would get to =ABS(F2-G2) is =IF(F2=0, ABS(F2-G2),F2-G2)

 

[mawar5530]

The formula in the code was

.Formula = "=IF(F2=0, ABS(F2-G2),F2-G2)"

it cannot produce =ABS(F2-G2).
It is not possible, you have altered something.
Even if you had the column formatted as text before the code ran the nearest any cell would get to =ABS(F2-G2) is =IF(F2=0, ABS(F2-G2),F2-G2)

Ok that find. i understand.

The issue is now, the formula should read as range F24, instead F2.
Please help me over here, about the formula i will check out.

 

[MARK858]

Make sure that column H is formatted as General before running the code.
Other than that then I can't help you as the code doesn't do that for me.
If you are really stuck then upload your workbook to a free file hosting site (either www.box.com or www.dropbox.com), mark it for sharing and paste the link it produces in the thread.

 

[mawar5530]

Make sure that column H is formatted as General before running the code.
Other than that then I can't help you as the code doesn't do that for me.
If you are really stuck then upload your workbook to a free file hosting site (either www.box.com or www.dropbox.com), mark it for sharing and paste the link it produces in the thread.

Report.xlsm

Shared with Dropbox

www.dropbox.com

 

[mawar5530]

Report.xlsm

Shared with Dropbox

www.dropbox.com

Please help.
In column H i have to formula to apply.
1= apply to all
2- selected field filter range

 

[MARK858]

What are you filtering by? Column H is headed as "Planned Date" with dates below is this correct and needs clearing?
Are you sure that you have uploaded the right file?

 

[mawar5530]

What are you filtering by? Column H is headed as "Planned Date" with dates below is this correct and needs clearing?
Are you sure that you have uploaded the right file?

Yes.

Column H to insert and later i will change the name is as "balance"
Column "D" filter.

But i have two formula apply in column "H".