Search results

Thanks Narayan for your valuable ideas and i am sorry for what i did. I am beginner in vba so i will upload the workbook can you please check and provide a solution. http://www.2shared.com/file/kBEEqpPZ/3_1_.html Thanks, Suresh Kumar S

Thanks Narayan, I have changed the code suggested by you but all the cells are highlighted. AA1 & AA3 should be highlighed since there is a difference when compared with A1 & A3. Public Sub Compare_And_Highlight() Dim rc As Range, ctbc As Range Dim ref_formula As String Set...

Hi Narayan, Thanks for you vba code i have changed as per your suggestion. But while running i got the below message for the following lines ref_formula = rc.FormulaR1C1 Error Message type mismatch Thanks, Suresh Kumar S

Hi, Can you please refer the below link. http://www.excelbanter.com/showthread.php?t=241282 Thanks, Suresh Kumar S

Thanks Narayan. I will wait for your reply.

Sir, Can you please try the below links or let me know which site i can upload. http://www.2shared.com/file/8OlLx8Af/3_online.html http://www.2shared.com/fadmin/48604557/9eefb8ee/3_online.xlsx.html Thanks, Suresh Kumar S

Hi Narayan, Please download the below file and provide a vba code. http://www.2shared.com/file/8OlLx8Af/3_online.html Thanks, Suresh Kumar S

Thanks Narayan & Kaushik for your replies. Narayan, Can you please give a vba code for such instance and i will upload the sample workbook by today evening. Thanks, Suresh Kumar S

Hi Kaushik, Thanks for your reply. I am sorry if i have not explained clearly.. Now i will explain in detail. Suppose Column A as some value which is working deponds upon some formula (A1=B1+C1) in the similar way column AA as the same value (AA1=AB1+AC1 but some times when we copy the...

Can you please upload the workbook?

Try AVERAGEIFS (if you have 2007 excel)

Hi Deb, Thanks for your quick reply. My concern is it should get highlighted in conditional foramt. Is that possible? thanks, Suresh Kumar S

Hi, I want to compare 2 formulas and if there is mismatch it should highlight(Conditional format) Example: A3 AA3 - No Changes $A4 $A4 - Highlight ( It suppose to be $AA4) Thanks, Suresh Kumar S

Hi, Combine 200057706&" "&OA then remove duplicate 2007 excel as. Thanks, Suresh Kumar S

Hi sukanta, I have gone through your workbook and I will try to find out the solution tomorrow. In the mean while our excel hero can help you. Thanks, Suresh Kumar S

Hi Sukanta, After successful uploading, you receive two links: a download link and a deletion link. Please keep both and share the download link. Thanks, Suresh Kumar S

Hi, Please upload the workbook with the help of below link. http://www.speedyshare.com/ Thanks, Suresh Kumar S

Hi, can you please refer the below link. http://www.simple-excel.com/excel-text-boxes.htm Thanks, Suresh Kumar S

Hi, Can you please refer the below link. http://www.allaboutoffice.co.uk/excopyvis.htm Thanks, Suresh Kumar S

Hi, I want a code if the active sheet as filter then it should msg "Filter available" otherwise it should apply filter. Thanks, Suresh Kumar S

Dear Faseeh Thanks, Can you please check my 2 download link file and suggest a formula. As per the above i am getting 12 for all rows. (Is it possible to upload the workbook ) Thanks, Suresh Kumar S

Thanks Bobhc, I want the column F to be updated by formula with checking with column I to O comparing with A to F. Now i have updated the information in the below sheet. http://www.2shared.com/file/T488mAHI/Book7.html Thanks, Suresh Kumar S

Hi, Please refer the below below sheet and give me a solution. (I want the result column to be filled by formula) http://www.2shared.com/file/AICNqcSJ/Book7.html Thanks, Suresh Kumar S

Thanks Hui & Deb

Hi, I have a source sheet and I want the result in the below file. I have explained what I want. Excel hero please suggest a formula and give an idea to overcome this issue. http://www.2shared.com/file/U5J2eaGa/Book1.html Thanks, Suresh Kumar S