Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default how to accumulate value and put in other sheet

Dear all, how to accumulate the value in table 1 and when next change
value or empty record recalculate and put in table 2 in different
sheet.
How to do in vba?
Thanks


Table 1
Item value
2110 50
2110 40
2110 10
Empty record in between
2330 94
Empty record in between
2450 120

Table 2
Item value
2110 100
2330 94
2450 120
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default how to accumulate value and put in other sheet

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"tango" schrieb im Newsbeitrag
om...
Dear all, how to accumulate the value in table 1 and when next change
value or empty record recalculate and put in table 2 in different
sheet.
How to do in vba?
Thanks


Table 1
Item value
2110 50
2110 40
2110 10
Empty record in between
2330 94
Empty record in between
2450 120

Table 2
Item value
2110 100
2330 94
2450 120


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accumulate values jk Setting up and Configuration of Excel 3 August 3rd 06 06:25 PM
accumulate exhausted everything Excel Discussion (Misc queries) 1 March 15th 06 03:24 AM
accumulate totals exhausted everything Excel Worksheet Functions 1 March 14th 06 11:30 PM
How can I accumulate time in a flight log? RossR Excel Discussion (Misc queries) 1 January 1st 06 05:50 AM
how to accumulate value and put in other sheet mango Excel Worksheet Functions 7 October 29th 04 08:42 AM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"