Results 1 to 4 of 4

Thread: Adding total and trasfering line in other sheet....

  1. Mar 10th, 2006, 03:12 AM #1
    luca90
    luca90 is offline

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Posts
    2,943

    Adding total and trasfering line in other sheet....

    ... with a macro is possible to summ the value into range ( G3:L.... ) identify from the index into column C and trasfering the line of summ into sheet TOTALE...

    Example:
    i have insert the index CB450021 (range of summ G3:L11) and CB450022 (range of summ G12:L18) the related summ into sheet TOTALE, the next line is refered from CB450023, ecc...

    Hope understand me...

    here the file:http://www.mytempdir.com/505626
    Reply With Quote Reply With Quote
  2. Mar 10th, 2006, 03:55 AM #2
    d3gerald
    d3gerald is offline
    Frenzied Member d3gerald's Avatar
    Join Date
    Jan 2006
    Posts
    1,348

    Re: Adding total and trasfering line in other sheet....

    to be honest with ya, i hardly can. but anyway, can you expound more of the problem
    On error goto Trap

    Trap:
    in case of emergency, drop the case...
    ****************************************
    If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option.     if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
    Reply With Quote Reply With Quote
  3. Mar 10th, 2006, 04:09 AM #3
    Sahir
    Sahir is offline
    Member Sahir's Avatar
    Join Date
    Jan 2006
    Posts
    38

    Re: Adding total and trasfering line in other sheet....

    Quote Originally Posted by luca90
    Hope understand me...
    Not much. Maybe you want to do something like this ?
    Code:
    Private Sub CommandButton1_Click()
  Cells(4, 1).Formula = "=SUM(A1:A3)"
  Worksheets("Sheet2").Cells(1, 1).Value = Cells(4, 1).Value
End Sub
    Yo soy yo y mi circunstancia - José Ortega y Gasset
    Und wenn du lange in einen Abgrund blickst, blickt der Abgrund auch in dich hinein - Friedrich Nietzsche
    Reply With Quote Reply With Quote
  4. Mar 10th, 2006, 07:14 AM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Adding total and trasfering line in other sheet....

    Excel VBA question moved to office development
    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


Click Here to Expand Forum to Full Width