Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Community > MacNN Lounge > Help with Excel 2000 for Windows

Help with Excel 2000 for Windows
Thread Tools
Junior Member
Join Date: Jan 2005
Location: Olympia, WA
Status: Offline
Reply With Quote
Jun 16, 2005, 09:57 AM
 
Does anyone know about scripting for Excel 2000? I need it to sum up the numbers in cells from each row that has the same date in another column, then place that number in another column, but only in the last row to appear that has the given date. It would need to do this ten to twenty times within the sheet. I hope I was able to describe it somewhat coherently. I'm pretty sure that macros can't do it, and I know I could do it if I could write a javascript or C program. Thanks in advance for any help that anyone can give me.
     
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status: Offline
Reply With Quote
Jun 16, 2005, 10:24 AM
 
I'm not clear on what you want to do, but I'm 95% sure it can be done without VB, javascript or C.

This part doesn't make sense to me:
I need it to sum up the numbers in cells from each row
that has the same date in another column
You have data in a row, but corresponding dates in another COLUMN ?

Can you PM me an Excel sheet with random data or post a pic of it ?

-t
     
Addicted to MacNN
Join Date: Jan 2003
Location: Great White North
Status: Offline
Reply With Quote
Jun 16, 2005, 07:40 PM
 
screenshot would help
Brian says (9:16 AM): I was looking at houses in Ottawa... I actually have a temptation in me to move
Jeff ******* says (9:19 AM): Eww, Ottawa is gross. It's infested with politicians, and presently, 1 Harper as well.
     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 01:27 PM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2