Hello forum,
I have an excel table which i have to summarise the content in the table, the contents in two consecutive rolls needs to be mergered together to become one roll, altough i do not know how to explain this better. But i have attached a sample which shows the problem and the solution by the side.
Hope excel worksheet function will solve these.
Last edited by shamade2107; 11-03-2009 at 02:42 AM.
Easiest way is with a macro for stuff like this. Run this macro on a copy of your sheet.
===========
Please Login or Register to view this content.
How to use the macro:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet
The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Many thanks forum, I was unable to access internet for the past two days however the macro works fine. IS there any way to make this macro work by clicking a botton as i will continue to update the work sheet.
Use the Forms Toolbar to draw a button on your sheet. It will popup and ask you to assign a macro to it, select this one.
==========
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks