Search results for query: *

Skip!! Your the greatest! I dont know what I did previous, but when I remade the entire thing here at home, it works like a champ. I aspire one day to actually understand how you came up with this function, its quite far beyond my abilities. I think what I need to do at work is just...

Skip, Sorry it took so long to get back with you, I've had a busy day... okay, so I'm home now and now I'm reconstructing the worksheets from work from printouts... I might be at this for a while, when I'm done, Ill upload the forms to the site so that you can tell me what I'm doing wrong...

Field1 =Sheet2!$BN$69:$EG$78 Field2 =Sheet2!$BN$79:$EG$79 Field3 =Sheet2!$BN$80:$EG$124 Field4 =Sheet2!$BN$125:$EG$125 Field5 =Sheet2!$EH$69:$ES$78 Field6 =Sheet2!$EH$80:$ES$124

Skip, You are absolutely right, and yes, I know it doesn’t calculate the value. I just cant seem to get it to return the value. okay, so here is how I have it set up... let me know if were on the same page... I copied your latest macro to my personal.xls into a new module labeled LKUP. I...

Skip, I must be doing something wrong, cause I cant get it to work. Later this afternoon when I get home and have more time, I'm going to upload the two spreadsheets so you can check behind me. this is what I did, incase it pops out that I blatantly did something wrong... 1. I copied the...

lots of empty values.. but these... AAT,TGA,GAT,GGA,TGC,CGA were just the tip of the ice burg... there are literally hundreds of fields, and some go from 1/8 all the way to over 2 while others will have only only a few (1/8 to 1/2). I didn't put all of them on there, just made it small so...

Oh, one more thing... I cannot add any code or change the grids/tables in any way.. I can only view them. They are owned and updated by someone else..

okay, here is an example of the grid that I'm working with. this is not the actual grid (as thats at work) but very similar. I have to use this on a daily basis, to look up multipliers. and mistakes would be very bad. As you can imagine its quite time consuming. Most of the grids I work...

Yes and no... let me try to explain this way... yes no yes no [ a [ d e f a [ d e f a [ d e f a [ d e f b [...

I just want to look up the value on the table, then paste that value into my worksheet. problem is the table is rather complex and busy. (serves as several tabels in one.) So what I want to do is simple, I just cant seem to figure out how to do it with this table. I wish it was as simple as...

Good afternoon everyone, I would like to set up a macro, I have some experience in visual basic, so I know the steps that I would take to create this macro, I just don't know how to search through a column or a row for a specific value, then to save only the value identifying only that column...