Recent content by cubstyled

not a problem cub

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim str As String Dim cboTemp As OLEObject Dim ws As Worksheet Dim wsList As Worksheet Set ws = ActiveSheet Set wsList = Sheets("ValidationList") Cancel = True Set cboTemp = ws.OLEObjects("GroupCombo") On Error...

Skip That's exactly what I am working on now. I am creating a workbook to do a form off of and I will update the other workbook via a macro when it is opened cubstyled

I was looking to do a dump but it looks like it will be the old fashion way. There are multiple reports that our VP runs in his costing and operational runs for our floor control (multiple calculations from two different systems -- i know it sucks!). Unfortunately this part of the system is not...

Thanks to all who have posted. You aren't telling me anything I don't already know. The reason for this was the operations will never change only the rates and that will be twice a year. I was trying to make things easier for those changes for non tech users, so when they get the updates that...

Skip, You must be a programmer! never taking in account that end users are not techies and what's with the attitude not all programmers are gods and I posted my question to get an answer not get flamed by someone who obviously does know the answer or just can't find an answer

Patrik , thanks I'll give that a shot

So you are saying keep all operations and rates in the same columns? I am trying to avoid this because I don't want 5000 or more lines. This is for ease of use I'll be creating it but wont be using it. I work with SQL and Access on a daily basis and I am aware of my benifits and lack there of...

I hope this is what you want Sheet1 Column A name range "Group" DNeedle ZigZag CleanMerrow Column C name range "DNeedle" 2N DOUBLE NEEDLE 2N01 2N AH & LEGS 2N08 2N SET STITCH 2N080001 2N SET STITCH Column D is included with Column C in name range "DNeedleRate" .25 .35 .45...

Reason: easier readability for the static data Question: How do I create a vlookup that will look at 2 different named ranges? I can do one named range but I will be eventually using many. I'm not sure what you mean about common lookup value -- Forgive me I'm not very well versed in advanced...

I have a work book all data validation is on sheet1 and sheet2 holds two combo boxes that validate against each other through vba. I am trying to do a vlookup that validates to 2 named ranges incompasing 2 columns per name. I want to do this as aposed to puting everything in just two columns and...

Thanks so much for all your Help

I forgot an "s" in names so ignore the error but I would like to know the breakdown of the command you had me paste thanks

I just get #NAME? In C1 I take it when I cut and pasted the Defined names went with them, what happens if there is a same name and different rate? There shouldn't be if the defined names for a cell range still works ( i4:i6 contains bill defined as marketing and i10:i13 contains bill and a...

I am using 2k, the list boxes worked great for validating agianst one another but with adding the rates in I couldn't figure out how to get them to validate agianst the individuals in marketing and so on. I'm not sure how to go about this now that it's not just two columns. I am not a...