array vb script needed with some info

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
618
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
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,999
Messages
5,508,686
Members
408,690
Latest member
Lip Renan

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top