array vb script needed with some info

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
625
Hi
I have a four column pivot table from a five column data table. The missing column is an account number that repeats itself on each row from the data table. The PT sums up and totals each of the division costs. Some divisions repeat and may have a negative, positive or 0 value. Some zero values may have decimal places beyond three.
I need to look at each line, and use an if statement something like
if (round (column3 amount),2)<>0 or if(round(column4 amount),2)<>0 then the row and move to a different table, otherwise don't copy and move to the next row))))))
I hope that makes sense.
Now I was hoping someone could help me out with this. More so that I learn from what you've done to help.
I'm not familiar with PTs all that much; and I'm not familiar with arrays although I'm trying to read about them both.
Thank you and good luck :)

- g
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,133,161
Messages
5,657,168
Members
418,363
Latest member
Debating_Earth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top