Consulting

Results 1 to 3 of 3

Thread: summing range of row

  1. 01-04-2008, 02:09 PM #1
    sal21
    sal21 is offline
    VBAX Contributor sal21's Avatar
    Joined
    Jul 2004
    Posts
    116
    Location

    summing range of row

    sorry but i think this question go here...
    http://www.vbaexpress.com/forum/show...268#post128268
    Sal
    1 help 1 pizza
    2 help 1 pizza 1 caff?
    3 help 1 pizza 1 caff? 1 mozzarella
    ...
    Spaghetti, Lasagne and Tortellini for the "Lady" ;-)
    Reply With Quote Reply With Quote
  2. 01-04-2008, 02:24 PM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Answered there.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 01-04-2008, 03:06 PM #3
    stanleydgrom
    stanleydgrom is offline
    VBAX Tutor
    Joined
    Nov 2006
    Location
    North East Pennsylvania, USA
    Posts
    203
    Location
    sal21,

    Here you go - see the attached workbook "Cartel1 - sal21 - 20080104.xls".

    I added a Worksheet_Change Event that will monitor column A. Each time you add an entry in column A, field title "UFF. AG.", the formulas in column N will be updated, and the formula in cell N3 will be updated dynamically.

    Have a great day,
    Stan
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules