Jump to content

hnmurugan

Member
 View Profile  See their activity

  • Posts

    20

  • Joined

  • Last visited

  • Donations

    0.00 USD 

  • Country

    Singapore

 Content Type 

Posts posted by hnmurugan

    Excel Hyperlink

    in Microsoft Office

    Posted · Edited by 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

    0

    Excel Hyperlink

    in Microsoft Office

    Posted · Edited by hnmurugan

    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

    0

    Excel 2007 complex formula

    in Microsoft Office

    Posted

    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

    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.

    0

    Excel 2007 complex formula

    in Microsoft Office

    Posted · Edited by hnmurugan

    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

    0

    Excel 2007 complex formula

    in Microsoft Office

    Posted

    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

    0

    Excel 2007 complex formula

    in Microsoft Office

    Posted · Edited by hnmurugan

    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.

    0

    Excel 2007 complex formula

    in Microsoft Office

    Posted · Edited by hnmurugan

    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

    0

    OEM to VLK?

    in Windows XP

    Posted

    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

    0

    Drivers Instalation in Post-Install stage (New Method)

    in Device Drivers

    Posted

    Sorry... further trial and error reveals that it can achieved by creating below entries.

    [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\DriverSearching]

    "DontSearchWindowsUpdate"=dword:00000001

    "DontPromptForWindowsUpdate"=dword:00000001

    if you can add this to your program before the wizard pop up it should be fine. Then set it back to its original value same as you set registry path.

    Hope this might be a solution.

    Regards

    Hari

    0

    Drivers Instalation in Post-Install stage (New Method)

    in Device Drivers

    Posted

    Hello....

    Below should work without any issues. I have tested it.

    Click Start, right-click Computer, and then click Properties.

    On the System Properties dialog box, click the Hardware tab, and then click Windows Update.

    Select Never check for drivers when I connect a device.

    Somehow if it can be achieved by your exe doing same as set registry path, then your problem is over.

    i have tried http://www.pctools.com/guides/registry/detail/1217/ with no luck.

    Regards

    Hari

    0

    how to copying i386 folder during Installation

    in Unattended Windows 2000/XP/2003

    Posted

    Press Shift+10 during the GUI portion of setup will bring dos window. use xcopy /S i386 C:\i386 to copy setup files to hard disk. Again press the same to bring up dos window and type regedit to go in to registry to change the source path. please be aware that installation will change back the source path again for some reason which i do not know. So it is advisable to change after completing the installation. Hope it helps.

    Rgds/Hari

    0
×
×
  • Create New...