Search results

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...

@Anamika Please have a look http://answers.microsoft.com/en-us/office/forum/office_2007-excel/allow-multiple-users-to-access-and-fill-in-the/aba97e43-f2b0-47d6-84d6-10a948c4311a ND...

@Izu Welcome to the forum, glad you are here Please download the file again and Press the Alt + F11 there you will find a UserForm1 press the F5 button then change the text from the Combo List and see what happen. if any issue please come back again with full details actually what do you...

@Subageethan Sorry for my late replay just i was out way from this Forum for long time so i didn't check any posts here, i think your problem may solve if not then please re-post with new question @KapooK Can you elaborate us what do you mean may be some body help with your problem or me...

@Somendra Misra The Drop Down list is showing only for Text in the particular Columns and not for Dates and Amount too Thanks for your feedback Regards SP

Faseeh bhai kainse hain, bahut din ke baad me chandoo.org me access kiya hum bhai mera eak request hain oh kya hai ki mere liye ek Inventory UserForm banayenge kya o bhi 10 to 15 items with party name, bill no and date ke sath. mein bahut dhunda hain Google me magar result 0 aapka sahayata ke...

@James Perry if Possible please upload a sample file for better knowledge to the forum readers and Ninja's too Thanking You

Hello Sir, after long time i back to my home town and now i am in work. Sir sorry to send this private Msg, i have small doubt that is is it possible to use the Advance Filter option for Selection Columns to Extract in another Sheet with VBA if possible please give me some idea about that...

@uday sorry for my late replay, actually i am busy with my personal work please refer the link it will give you some idea for shrink http://www.andypope.info/vba/resizeform.htm and http://vba-corner.livejournal.com/1392.html Hope it clear other wise please inform Thanks SP

@Hussein already we told you to upload a sample file so Please upload with your exact requirement Thanks SP

@Rej as per my knowledge there is no option to turn off the R1C1 Style in VBA or VB so when ever we record a macro through record macro from excel file then it by default it's take the R1C1 Style but the formula is working as we desire. if you want to know the formula then select the Range A1...

@Sara please try the below code Option Explicit Sub CombineFiles() Dim Path As String Dim FileName As String Dim Wkb As Workbook Dim WS As Worksheet Application.EnableEvents = False Application.ScreenUpdating = False Path = "C:\Users\user\Desktop\Sara" 'Change as...