hnmurugan

Hi all, Would appreciate if you any of you can share your knowledge on below. Some of our users are facing a strange issue with excel 2007. The scenario is, Summary.xlsx A1 - hyperlink to template1.xlsx A2 - hyperlink to template2. xlsx A3 - hyperlink to template1A.xlsx where it was created using save as function from template1.xlsx A4 - hyperlink to template2A. xlsx where it was created using save as function from template2.xlsx note: all the templatexx.xlsx files in the same folder as summary.xlsx (network share) The problem occurs when try to open hyperlink in A3 where it is opening the template1.xlsx instead of template1A.xlsx. I have ruled out the possibility of user hyper linked to a wrong file as the text description of the link in A3 clearly states as template1A.xlsx. Regards Harry

Hi Geeks, Need your assistance or advise. Is it possible to change the index value of a combo box by hyperlink. Please refer to attached excel sheet. In summary sheet, as you all know it is possible to hyperlink to results sheet. As you can see then we have to manually select the students to see the results of the particular student. Is it possible to change the index value via hyperlink then the rest will be changed automatically? Thanks in advance for your time and contribution efforts. Hyperlink Demo.zip Regards Hari

Hi jaclaz , Sorry. Did not have chance to say thank you last 2 weeks. Really appreciate your help and i was able to achieve what i want. Best wishes. regards Hari

Well, I simply thought that a Driver is a Driver and a Tech is a Tech, and "coupled" "employee#" with Designation. You can simply overwrite the formulas in colums "Designations" and write the Designation manually or choose it from a list. jaclaz Noted. Thanks for your help. I figure out why below was not working D3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,3) E3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,4) F3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,5) Changed as below and changed the designation column value in tables sheet as DES1_4, DES1_8 and so on. It's working now. D3 formula =VLOOKUP(($B3&"_"&$C3),Table!$A$2:$E$53,3) E3 formula =VLOOKUP(($B3&"_"&$C3),Table!$A$2:$E$53,4) F3 formula =VLOOKUP(($B3&"_"&$C3),Table!$A$2:$E$53,5) Hmm...It is not over yet... Give me some time to test and will post back the results with 1 last requirement. Once agin thanks fro your help.

Please correct me if i am wrong. Based on quick look on your example Totalhrs is mandatory were as designation is not. I require the designation as mandatory. Example: A employee may work as des1 for day 1 and as des4 for day2. Regards Hari

Updated to office 2003 file format. The table structure in requirements.xls may not allow lookup conveniently, thus i have changed in vlookup.xls. Requirements_2.zip Based on vlookup.xls, i have tried as below with no luck. D3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,3) E3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,4) F3 formula =VLOOKUP(($B3&$C3),Table!$A$2:$E$53,5) Any help is greatly appreciated. Regards Hari Vlookup.zip

I am sorry to say this. I have not provided the requirements clearly. Thus i will treat Demo_revised_2.xls as stage 2 and hold it. Please consider / refer to your Demo_revised.xls with attached and please clarify with me if something is not clear before try anything. Requirements.zip

Jaclaz - I am not sure to have any clearer understanding than I had before Hari - Honestly i did not explain clearly or you did not understand clearly. Jaclaz - Unless I am grossly mistaken the attachment contains only a bunch of Excel sheets with NO formulas, but values Hari - It was partially implemented thus no formulas, My initial request is to to deal with the formulas, Your reply is to deal with values. Quote Thanks for your effort. I admit that you have approached the problem differently by listing the possible values in a table then do a lookup . My idea was to look up for the formula and perform the calculation. Your idea looks interesting and i will give it a try and post the results. Unquote Jaclaz - What I am I supposed to do with it? Hari - Can you please help when i am stuck while trying your suggestion. Ok... Let me request in a much clearer way. Disregard all except demo_revised.xls and consider the two work sheets Sheet Vlookup_Example - take the total hrs, check the designation and lookup for the value in tables sheet and list the value + (check must be 0) I think understand this clearly Sheet Tables - list all the values for each designation Designation 1 - Normal =a, Ot1.5 =b Designation 2 - Normal =c, Ot1.5 =d Where we tried it for example. a,b = 24 (total hrs) c,d = 24 (total hrs) Is my understanding clear? I am testing it as below example where initially the break deduction was not highlighted. Example: 7:30 to 18:30, then total hrs =11 If designation 1 weekday Add /assign 8hrs to basic, deduct 1hrs for break, Add /assign 2hrs to OT1.5 If designation 1 sat Add /assign 4hrs to basic, deduct 1hrs for break, Add /assign 6hrs to OT1.5 If designation 1 Sunday Add /assign 0hrs to basic, deduct 1hrs for break, Add /assign 10hrs to OT2.0 Since i believe you expertise (to guide or inspire not doing the job for me) can offer solution much quicker than me, can the demo_revised.xls accommodate this situation? if not can i use this? http://www.spreadsheet123.com/excel_tut/ex.../if_custom.html regards Hari

Not meant for show case. It is to enable you with more info to have a clear understanding. I have tried your solution partially (without implementing the vlookup). refer to attached. regards Hari Manhrs.zip

Thanks for your effort. I admit that you have approached the problem differently by listing the possible values in a table then do a lookup . My idea was to look up for the formula and perform the calculation. Your idea looks interesting and i will give it a try and post the results. However i have attached the actual worksheet for you to have a look.

As requested. Can't upload excel, so zip it.

Hi Jaclaz, Thanks for your reply. Please refer to attached. I am not so sure if i can use vlookup to do the job. My understanding is vlookup find the value based on the conditions then present the value. My requirement is attached. Please correct me if i am wrong. Regards Hari Demo.pdf

Hello All, I run in to a unique situation and requesting your advise / help on below. Cell A1 = Apple Cell B1 = if a1="apple", assign this formula, if a1="orange", assign this formula, if a1="Mango", assign this formula Is it possible to do? The reason for above request is "assign this formula" already have several if conditions and it is very difficult to edit. Currently i am using if condition=true do this else do that (Apple do this, non apple do that) Now i have to check for orange and mango in b1 itself I have listed all the formulas in a separate sheet and try creating name (define names for a specific cell or range) but it only take the values not the formulas. Any ideas?.Please let me know if you want me to post a sample. Regards

Visit www.nliteos.com and download the tool to create a new bootable cd with drivers.

Just to explain further, windows product key update tool will replace or modify dpcdll.dll & pidgen.dll which is required to generate the installaion ID. It is safe and reliable way. However please do find a way to remove unnecesary junks bundled with OEM preinstallion. There are tools available to remove it. Regards Hari