Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 15th, 2011, 10:52 PM
Registered User
 
Join Date: Jul 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel Update options

Hi everyone

I need solution for one of the problems i face with updating a cell

my cells are like this

Cell C1 will have sum(B1:B10)

Cells B1 to B10 change daily with a condition b1 = (If(D1=0,e1,0) here d1 will have a positive value only once in a month and all other 29 days it will be zero 0

Similarly B2 to b10 will have one value once in a month and remaining time it will be zero.

C1 should be updated whenever there is value change in b1-b10

it stores only one value since it is sum of b1:b10 .. I need it to get updated with the previous sums also

In My case it should have sum of 10 numbers by the end of the month.

I check the conditions this way =MOD(d1,30) so its going to be 0 only once in a month . When d1 =0 then B1 will get a value to its cell so B1 will have only one positive number in a month.

regards
Prabhu
 
Old July 16th, 2011, 01:02 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

And the problem is???
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========





Similar Threads
Thread Thread Starter Forum Replies Last Post
Update excel object in Word slamdunk Word VBA 1 May 26th, 2010 11:34 PM
Update links in excel file Wall st Guru Excel VBA 2 December 11th, 2006 05:09 AM
vba recodeset update (Excel) stepdev VB Components 1 October 20th, 2006 09:17 AM
Update Excel File Using ADO .Net briancronin123 ADO.NET 0 June 3rd, 2004 02:20 AM
Update excel cells on change of another program pjhlin VB How-To 2 January 20th, 2004 11:56 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.