Search results

You can find the solution here: https://hotfile.com/dl/203208928/a543484/ML_Rosters.xlsx.html I have added some extraneous values in column A (highlighted in bold )of sheet 2 to represent the actual situation. I am assuming that columns B to I in sheet 2 have other information. 1) In...

Hi Nitesh, You can find the solution here: https://hotfile.com/dl/203206731/448280d/lookup.xlsx.html

Hi Stacy, This can be done using Excel. Could you please post a sample worksheet and send me the link? Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook PK

Hi All! I am trying to dynamically assign column width for each column in a listbox. I am calculating the maximum length of a string in a column and assigning maximum length + 5 as the column width. But when the list box pops up after the code is executed, all the column values still remain...

Click one any one of the cells in the table and press ctrl+A PK

Hi, If I understand your question right, I think what you are looking for is dependent lists validation. Google "dependent list validation excel". Let me know if you have more questions. PK

Hui, Thanks a lot! it works great! Appreciate your help. Regards, PK

Hui and Shrivallabha, Many thanks to both of you. I really appreciate your help! Hui: I tried your method. However I kept getting this error "Run time error 381: invalid array property". Could you please tell me how to fix this? Also, I have uploaded a sample file.Could you please tell...

Hi Everyone, I was wondering if there is a way in excel-vba to do this. In sheet A, I have 10 tables. Each table is assigned a table name and has two columns (a list of fields in column 1 and the corresponding data types in column 2). I have added a hyperlink to the cell which contains the...