Search results

Yuppie!!~ Bobhc Sir, u made my day this is exactly wat i needed... thanks a lot.

Ty sir, as u said exactly wat i am expecting too i need like u gave below So if you choose Quality control then you only want to see QC_1 QC_2 QC_3 QC_4 QC_5 QC_6 QC_7 QC_8 in the task sheet? >> Yes, i need like this :)

sorry but i need those task in data validation. `example: if i select Content reviewer in role it should show only the content reviewer's task in task column with data validation P.S: just like forms which will be in some internet registration page.

Hi All, i need a help on file which is in below given link. https://app.box.com/s/8muubfilwvmz0fmfx383 When i select data validated value in role column which is in Sheet1 it should only the role related task where the table in SRC sheet. This should be a formula or a macro.

Hi Narayan Sir, this is exactly what i need but how can i do this on macro?

Hi All, i have 2 columns with values and i need it to calculate as percentages. like, if A and B Column has 100 and 50 then i need it to calculate as 100% and 50%. Please help.

thanks a lot Sir... u helped me a lot i understood a lot with this macro. :)

Hi Sir, i understood the macro... But what my question is instead of colouring the cell is there an other option like no-fill(no colour) in Case Is section

Narayan Sir ...It worked like a charm. Ty and one more request sir how can i give No fill in Case Is >= 80% cell.Resize(1, 4).Interior.Color = vbSGreen ?

yes sir and should apply same law/condition for same range of cells too

no sir. even this last macro is not working on it Scenario: when A% and B% is applied with the condition then only those 2 columns should be higlighted and same case applies with C% and D%. condition is all we need to apply :( Condition: (A+B) >= 90% = Purple 90% >(A+B)>=...

Hi Narayan Sir... the above macro works only on A% and B% i need it for all A,B,C,D. and please let me know how to add different colours too.Thanks in advance.

Hi Sir, Please check the below attached sample paper. and i need to apply condition(coloured) as given in my 1st post and that will get hightlighted on calculations + column E, F, G, H... https://www.box.com/s/xqos9y3n84q4ojzzren6 like if A + B >= 90% then highlight E and F column in...

Hi All, i have below macro using. But what i need is instead of giving the keyword like Extreme, medium, low or something. can anyone please let me know how can i use aggregate percentage for each cell... like given on below given condition and i need to make 4 columns like a, b, c & d at...

wow thanks shrivallabha sir it worked like a charm :)

Sir it actually dint work what i am doubting on is trFile = Dir(strInFold & "*.docx", vbNormal) or strFile = Dir(strInFold & "*.docx", vbNormal) has problem with it.

Hi all, I am using below macro to remove Document Properties, Personal Information & Custom XML Data. but what i am facing is when i run this macro all the .docx files will be as same extension. But when .doc and .docx will be mixed in the folder then it automatically changes .doc file...

Wew... thank you Narayan Sir... works like a charm :)

Sir, Thank you but what i need is the option ID, that is if option D is highlighted i need D as answer key. same follows to other rows

Hi All, Please help me with below find, which has Highlighted cells like option A, B, C & D. so when Option D is highlighted i need the Cell Value of it in Column Answer Key. same follows to each and every rows. https://www.box.com/s/xf8h8qujh7mnsjxclw6n

Anyway this information is enough but sorry for ECHO's Problem :)

oh ok thank you.

Thanks for your quick response sir... But why i asked is when i do a mail merge. I need the picture to come on Outlook/Microsoft Word document. Please let me know any alternative if you have any.

Hi All, Please let me know how can i insert a picture inside a cell i.e. Pressing F2(edit mode) and inserting. Thanks in Advance,