Search:

Type: Posts; User: farrukh; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.03 seconds.

  1. Match columns A,B in two sheets and Bring ColumC data

    Hello All,

    I have two worksheet having (Match1 ) Sheet and (Match2) sheet . I require match1 sheet column AB with Match2 sheet if matched then bring column C of Match2 sheet to Column C in Match1...
  2. Daily,Weekly,MTD, YTD, LTD Sql query range wise

    Hello Experts !
    I need to show the sqlserver database data like Daily ,Weekly, MTD, YTD and LTD. I googled and find sql query example in it but one link for using calander table no longer exist ....
  3. Sir, Please find attached the sample excel file...

    Sir,
    Please find attached the sample excel file please.
  4. Open attachements based on start date end date

    Dear Gurus,

    I need calendar control in first column start dates and second column end date (end date fixed by user) third column The names ,fourth column PDF files extensions and fifth videos...
  5. Dear Daianel, Many thanks for your reply ,no...

    Dear Daianel,
    Many thanks for your reply ,no still I unable to get any solution or way to resolve this issue... I am doing manually after generating my report. Please help

    Best regards
  6. Mandatory entry in column if other column values less than 24

    Hello Experts!

    I have column C which contains hours on and in column O is blank for code entery. I need if column c Values less then 24 so a popup comes you need to enter the code in the column O...
  7. Replies
    10
    Views
    662

    Sdckpar many thanks worked perfectly... Thanks...

    Sdckpar many thanks worked perfectly...
    Thanks for help
  8. Need five days average of stable values for stable unstable data

    Hello All...
    I have column which contains stable unstable data. I need to get the last five days average of stable data when unstable values comes. I mean last five days average of stable days.
    ...
  9. Replies
    10
    Views
    662

    Ahh sorry in the sampler i copy paste the...

    Ahh sorry in the sampler i copy paste the values.Please see the attached spreadsheet what i am doing wrong.
    :confused::confused:
  10. Replies
    10
    Views
    662

    Thanks Sdckpar, Exactly your post # 4 works for...

    Thanks Sdckpar,
    Exactly your post # 4 works for me . I am unable to fix the below formula to get the sum.

    =SUMIFS(Caculation!$G$4:$G40,Caculation!$B4:$B40," >="&B4,Caculation!$B4:$B40,"<="&C4)
  11. Replies
    10
    Views
    662

    37225 Hello sdckapr, Sorry i think i unable...

    37225

    Hello sdckapr,

    Sorry i think i unable to clear my forum help.

    Actually the Sum sheet will be created automatically there is no match case.
    I have given the coloring to cells to make...
  12. Replies
    10
    Views
    662

    37212 Hello sdckapr, The formula will get...

    37212

    Hello sdckapr,

    The formula will get me the sum from calculation sheet but what about date range. For date range i need if dates are going in the sequence suppose 2-nov-13 then 3-nov-13...
  13. Replies
    10
    Views
    662

    Get Sequence of Date then sum in sum sheet

    Hello Gurus,

    I am really stuck in my senario please help me out.

    I have one calculation sheet and other is Sum sheet. In the calculation sheet dates are random suppose in the month of november...
  14. Thanks sir works perfectly :)

    Thanks sir works perfectly :)
  15. Sir RetiredGeek, Thanks very much it is...

    Sir RetiredGeek,

    Thanks very much it is exaclty my need, just only if the values having decimal places the function does not count correct average. The sample is attached.

    Thanks Sir
  16. IF find Zero average the previous 5 values greater then 0

    Hello All,

    I need some formula works if in the column find zero then pick the average of last previous 5 values by excluding zeros. The file is attached with required results.

    Thanks in advance
  17. Respected Zeddy, Awesome ! Thanks you really...

    Respected Zeddy,

    Awesome ! Thanks you really i dont have words to say thanks...

    God Bless you always...
  18. Respected Zeddy no issue have a very safe Journey...

    Respected Zeddy no issue have a very safe Journey precious man... if possible will you share your picture want to see a kind man to humanity.
    Email=farrukhhameed786@gmail.com
  19. Hello Respected, Thank you very much for...

    Hello Respected,
    Thank you very much for reply...
    I want to append the data in master workbook beneath each other.

    I am attaching the Sampler test.xlsx and Master.xlsx . In the Master file the...
  20. each worksheets in a folder copy header and last row paste masterworkbook

    Hello Expert !
    I need your help... I have worbooks in folder each workbook contains three worksheets with same names in all. I want that the vba copy make three sheets in master workbook and all the...
  21. Paul, Will this software works on mapped...

    Paul,

    Will this software works on mapped network drive supppose i have full permission to on folder and subfolders to network drive share?

    Thanks
    farrukh
  22. Network folder reterive all permission of folder

    Hi All,

    I have a folder on network and i have full rights to that folder. I need to get all the group or usernames with their permssion as a list . The folder contains sub folders as well. Is it...
  23. Thread: Web query VBA

    by farrukh
    Replies
    1
    Views
    300

    Web query VBA

    Hello Experts!

    i need to automate the web query on password prompt and use static URL. When site open in New query ( i can select the dates of data manually in our website). Then click to import...
  24. Transpose data and Repeat header and Dates

    Hello Expert !

    I have data sheet i need to tranpose data based on repeate header column wise and dates also. The attached is the template contains two sheets one name is before and other sheet...
  25. Respected Zeddy, I have upgraded MS Office 2007...

    Respected Zeddy,
    I have upgraded MS Office 2007 to MS Office 2010. In Office 2007 the code work for me but in Office 2010 the Form does not load and it says attached error.


    3634636347


    Your...
Results 1 to 25 of 165
Page 1 of 7 1 2 3 4