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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Large document calculations
- Thread starter cac1219
- Start date
West Man
Well-known Member
- Joined
- Mar 27, 2006
- Messages
- 1,175
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.
Upvote
0
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.
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.
Last edited:
Upvote
0
