Search results

Thanks, But when I do the same and press enter it asks me to choose worksheet name as it does not recognize J17 as the sheet name. Kindly advise Regards Jay

Hello, I need some urgent help on the below explained. Link string - ='C:UsersjsarangiDocumentsFNNFY 2000Q2Working Files1 23 2000[FY13 Q3 Fnn Quarty Comson (01 23 2000).xlsm]Cypora'!$T$8 Need to give a cell reference to "Cypora (Sheet Name)" in the string. Kindly advise Regards Jay

I got it. thanks for your help. Regards Jay

Thanks Luke. I think I am not getting the point. Let me re-explain with the below example. The line graph below looks like this. -----------/---------/---------() Marker Marker Sliding marker (-5%) (10%) (this should change as per value) The sliding marker if...

Thanks for the update. I think I need to understand it better. Do you mean, I need to write IF statement in the data range of the marker? Let me know if I need to share the file. Regards Jay

Hi Luke, Thanks for the link, but I wanted something else or may be I am getting it incorrectly. Let me know if I need to upload any file so that it would be clear. Please guide me. Regards Jay

Hello, Please find below the problem description. I have a line chart with marker. The position of the marker changes according to the change in data. I need your help in changing the color of the marker automatically as the data changes. Lets say the range is between (-5%) to 10%. If the...

I do both. updating the numbers and changing the color also. but when I copy paste the format from below cell or press F2 then the formula updates. Any solution? Regards Jay

Hello, Please let me know if there is anything wrong in the below code. Because after updating the file I have to press F2 to get the desired result. It does not update automatically which I want. Kindly advise. Regards Jay -----------------Code------------- Function Colorfunction(rColor As...

Thanks all for your support.

ok, for example - A1:A3 contains x,y and Z and B1:B3 contains 100,200 and 400. I want values for X and Y using sumifs. so My answer would be 300. Kindly advise Thanks Jay

Is it possible to insert "AND/OR" function or a defined NAME range in sumifs? Please advise. Thanks Jay

Thanks all, it helped :)

Hello, Please advise me on VBA to print all active sheets in a excel file Regards Jay

I got the answer, thanks

Hello, Can we have both Label filters and value filters in pivot at the same time? Regards Jay

Hello, I need help on dynamic drop down. Below is the requirement. Cel A1, A2 and A3 contain 1,1 and 2 respectively. Cell B1, B2 and B3 contain A, B and C respectively. I want to have a drop down where I select 1 or 2 then in the next cell it will automatically show up the respective valude...

Thanks for the advise. will do that.

Well, I will share. Thanks. I need one more help on advanced drop down. Below is the requirement. Cel A1, A2 and A3 contain 1,1 and 2 respectively. Cell B1, B2 and B3 contain A, B and C respectively. I want to have a drop down where I select 1 or 2 then in the next cell it will automatically...

Thanks for the help. But I wanted something different. Did it manually actually. But if you find solution, please do let me know. Regards Jay

Hello, Is there any formula for below issue... Lets say - Cell A6 has yellow color, I want to write a formula in B6 having the logic - if cell A6 is yellow, then give me "Y" Kindly advise Jay

Thanks to all of you. It works now. :) Regards Jay

Hi Narayan, One problem - It also changes in hidden sheets. I want only in active sheets Regards Jay

Thanks Narayan, it works now. Thanks to all for quick guidance Regards Jay

Thanks for the quick reply but it's only changing in one sheet, it's not moving to next sheet.