Large document calculations

[cac1219]

I have a document with over 21,000 lines. The spreatsheet is totaling orders over the past year: each orange order amount and total charge is a hidden line and only the totals are visable, there could be 876 orders for oranges so when I copy and paste, all 876 lines plus the total (line I want) paste. I am trying to create a list of totals only without having to go through 1000's of lines, copy total, paste value and delet other lines.

 

[aaronbens]

Please provide a small data sample with column and row info

 

[West Man]

Select the rows to be copied then (in Excel 2003) select edit, goto, special and visable cells only. Then copy and paste. You should get the total rows only. In later versions there should be a method for selecting only visable cells.

 

[cac1219]

Item ID- Item- Qty- Total
53694- Orange- 346- 739.89
49872- Apple- 687- 1053.65

Totals are result of 100 lines added together that are hidden. I want to be able to grab only the total (visible) rows. I cannot figure out how to use 2nd reply in Excel 2010.

Sorry- could not figure how to insert real example.

 

[West Man]

Did you try my suggestion for selecting only visible rows?

 

[cac1219]

I figured it out- select cells. F5. Special Visible cells only.