Matching numbers to a total

dbooth

New Member
Joined
Sep 20, 2006
Messages
3
Hello all-

I am just getting started with more advanced excel techniques and I could use some help. Basically I have a short list of totals and a long list of numbers that make up each total, unfortunately these numbers are in no real order and therefore have to be sumed manually. I am looking for a macro to help tie the parts to the total.

I am more than happy to do the leg-work and search through archives/message boards, but I don't know what to search for. If anyone knows of commands or keywords relating to this, or specific code, please let me know.

Thanks
DB
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

dbooth

New Member
Joined
Sep 20, 2006
Messages
3
WOW...Thank you.

That is perfect. The code from the contest is over my head, for now, but I have added Andrew Poulsom's code in and it is working perfectly. Now I just need to go back through line by line and learn it.

Thanks for the help,

DB
 

Forum statistics

Threads
1,136,309
Messages
5,674,999
Members
419,541
Latest member
freddyboots

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top