Search results

@Pinang I am not sure It is possible and how much secure about our work As a blind sot just i tried a code please check Sub Formula_Hide() With Range("A1") .Formula="=Sum(1+1)" .Value =.Value End With End Sub Thanks

Bro do you need any more details about mine problem

Glad your problem solve

@Don Preston Sorry i can't understand, but what i understand i get the all borders and symbols in print preview what you have entered in Please Check the Attached Thanks

Hi Shrivallabha Congratulation on your 1st Mile stone keep watch guide us

@Sinu Please upload a sample file with your desire request i will try to solve your problem other wise our Ninja's too Thanks

@Dede Please start a new conservation Thanks

@Sinu Welcome to Chandoo.org, Glad You Are Here Please check this link http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/ and http://www.contextures.com/xlDataVal14.html Hope It solves your problem, if any problem please come back Thanks

HI Deepak can you do the same thing for me to search the dealer from This link https://odishatax.gov.in/portal/Shared/DealerSearch.aspx

It is a Rajasthan Commercial Tax Department Site and here it must need to login http://www.rajtax.gov.in:7777/vatweb/ after that we can do any thing

@Asheesh Welcome to Chandoo.org Forum, Glad You Are here please refer the Below links may be it will give some idea http://www.pcreview.co.uk/forums/powerpoint-chart-preview-vba-userform-t3463215.html and http://www.vbaexpress.com/kb/getarticle.php?kb_id=756 Thanks

Please don't cross post here it is like a spam http://chandoo.org/forum/threads/if-statement-for-dates.18088/ Already Luke M replied and he request something from your so try to replay there and sure you will get the result for your querry Ninja's kindly lock this for thread for further...

@sammyp1 i will try my level in this between may be our Ninja's can Help you on this Thanks

@bobhc The OP is asked about the date column which is some extract using with Advance Filter option for Dates

@kumar You can use the Advance Filter option to extract the data

Kumar@raja Please Try this formula with Array - Ctrl + Shift + Enter =SUMPRODUCT(MAX((Amount)*(Date="05-06-2014"))) Amount is column B and Date is Column A Hope it solve your problem Thanks

@paramnayak i am not sure what you think, if the cell is blank then the "-" symbol to be appear if cell is not blank then what? the result may be like this =If(A4="","-","") Then you will get the "-" if the a4 is blank Thanks SP

@jitesh54 Welcome to chandoo.org forum, glad you are here as per my guess is correct, you can use the Conditional format for highlight the duplicate data in particular Columns Please Follow the steps 1. Select the data 2. Select the Conditional Format in Home Tab under Style 3. Select...

Cross Posting http://chandoo.org/forum/threads/need-help-vba-move-data-from-one-sheet-to-multiple-sheets-customerwise.18016/ Ninja's please lock one Thanks SP

Please Upload a Sample File Thanks SP

@Rohit Kumar i think it is better to upload a sample file with your request and it is better to help you the forum reader and Ninja's Thanks SP

@sammyp1 if possible please upload a sample file with your request Thanks SP

@rdmqpr why not you try the advance filter option, please download the file and check if any problem please inform i have created a new tab named with Shop Data there i have mention as per your requirement Thanks SP

@Izu Please elaborate some more details, sorry i can't understand what do you say Thanks SP

@Puttaswamy Welcome to Chandoo.org Forum, Glad you are here Another method you can use the Offset Function Say your data in A1:A100 and you want to reflect the same value in another columns then just type in B1 = OFFSET(A1,0,0) now copy the formula and paste in your required columns from Ex...