Dear all,
please have a look at the attached file. The task is to fit the items in Column A on rolls that are 17.5 meters long. Each item has a specific length which is defined in row 2. I would like a Macro to automatically draw a line as soon as the maximum length of 17.5 meters is reached. Then start with the next items until a maximum of 17.5 is reached and so on...
Thank you !!
Last edited by 6StringJazzer; 03-06-2014 at 04:29 PM. Reason: title typo
This can be done with conditional formatting without a macro, if you are willing to use an extra column. My solution adds a column to show the running total length of the items on each roll. (It might be possible do this without the extra column but I couldn't think of one.) Then conditional formatting draws a line anytime the running total goes down, starting a new roll.
The extra column can be hidden if you don't like the way it looks.
Hi, thank you! But I would need a macro because the sheet will be filled with data from another sheet, plus a macro could automatically draw a line ...
Actually, it works great !!!!!
elgato74.xlsx
This may do it for you.
the row colouring is conditional formattimg
Last edited by tony h; 03-06-2014 at 04:07 PM. Reason: elgato requested a 2007 version
click on the * Add Reputation if this was useful or entertaining.
Does that solve your problem? If you really need a macro I can help with that too.Originally Posted by elgato74
I think i was set on a macro with a nice button, but a formula seems so much quicker.
I use macros all the time but if I can do it with a formula in a few minutes I usually prefer that.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.
Hi 6StringJazzer, could I ask for your Macro solution for this task ? I would appreciate it !
Macro solution attached
Helloi love the NICE BUTTON ! But sadly, it draws the first seperator line and then spits out an "438" Error Object doesnt support this property or method ".TintAndShade = 0" . i am using almost the oldest Excel Version on the planet
I have Excel 2010 and 2013 (dropped 2003 last year) so have no way to test this in 2002. I also do not know what limitations there are in VBA support in 2002. At first glance it appears that the TintAndShade property did not exist in 2002. I would suggest simply deleting that line ** code and trying again.
Yes, deleting the property did the trick. Thanks again & have a good day !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks