+ Reply to Thread
Results 1 to 14 of 14

Macro - sum up, compare, display. Plz help!

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    Macro - sum up, compare, display. Plz help!

    Hi Everyone! I already got a very big help on this site from someone and I hope this time there will be also someone who can help me.
    First of all I am not good at macros that is why I am asking for help.
    Here is my problem:
    I have a spreadsheet with three sheets („Data”, „20” and „30”). On the Data sheet I have only two rows, and I do not work on this sheet. I work with the sheets 20 and 30. On the sheet 20 I need to sum up the amount of column H. But my problem is that the count of this column (the rows or cells) allways change. Sometimes there are 554 the next day 663 and so on. So I need the macro to sum up the amount of column H two cells under the last cell. I need exactly the same in the sheet 30, but the only difference is that in the sheet 30 the amounts are in the G column (not in H). Finally I need to compare the two summed up amounts (sheet 20 and 30) and they must be equal. So what I would need as macro is that when I run it, it sums up the amounts in both sheets and then in the Data sheet (in the 5th row, cell A) displays the summed up amount and (in cell B) displays OK if the two summed up amounts are equal, or just dislpays ERROR if the summed up amounts are not equal.
    I hope you can understand my problem and you can help about it as I am doing this daily at least 2 times, and it would be very good if I could use a macro instead of doing this manually! Thank you for your attention! Thank you in advance!

  2. #2
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    Can't help anyone?? :(((

    Can't help anyone?? ((

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Can you attach an example workbook, remove any sensitive data and zip it?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    Thank you

    Sure..Thanx a lot. I made some notes in the file. I hope it is understandable. And thank you in advance!!
    Attached Files Attached Files

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Zip file appars to be corrupted.

  6. #6
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    sorry...

    Sorry...I don't know what happened to the file..anyway I rezipped it and checked it..this one should work.

    thanx again..
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    08-01-2007
    Posts
    110

    Thanks sooo much! :)

    Hey Roy! You made it! It works great!! Thanks a lot!!!! )) You are the man!
    Thanks again for your efforts!

  8. #8
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Glad it helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1