Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: nikeshtnt

Search: Search took 0.00 seconds.

  1. Answers
    4
    Views
    1,575

    Thanks for reply. PFA the downloaded file. ...

    Thanks for reply. PFA the downloaded file.



    Thanks for answer.. Right click option is not working
  2. Answers
    4
    Views
    1,575

    Few shortcut key in Excel is not active

    Hi,

    I have downloaded a excel file from website which has macro.

    While opening it says that Ctr X, Ctr V, & Ctr C will be deactivated, but even after closing the file Ctr X & All insert option...
  3. Answers
    4
    Views
    1,570

    Hi ScottGem, Thanks for your reply. However...

    Hi ScottGem,

    Thanks for your reply.

    However my query is different from your answer. I want to import from web to excel and format it as per my requirement



    Thanks
  4. Answers
    4
    Views
    1,570

    Webpage linked with MS Excel

    Hi,

    I know how to link a webpage with excel but most of the time it don't provide result as required. e.g. if I want a table of share price and chart
    1) Currently table format is not...
  5. Answers
    0
    Views
    529

    Webpage linked with MS Excel

    Hi,

    I know how to link a webpage with excel but most of the time it don't provide result as required. e.g. if I want a table of share price and chart
    1) Currently table format is not customized ...
  6. Answers
    1
    Views
    696

    Pain in back side of sole

    Hi,
    I am feeling pain in my sole (back side) for last one month.
    I had no history of joint pain or any injuries also changed my shoes after this only. Tried wear sports shoes too.

    But still it...
  7. Answers
    3
    Views
    695

    I think you are not getting what you need as per...

    I think you are not getting what you need as per your mind.
    So stop thinking and try to know what makes you wet at below.. like forplay for long time, sit in front of mirror and like your and so...
  8. Answers
    10
    Views
    3,040

    Thanks for your suggention. I have got some...

    Thanks for your suggention.

    I have got some alternatives..
  9. Answers
    4
    Views
    729

    Thanks, Please elaborate the process for using...

    Thanks,

    Please elaborate the process for using movie editor
  10. Answers
    10
    Views
    3,040

    What you have written is right but unfortunately...

    What you have written is right but unfortunately not sutailble to me.
  11. Answers
    10
    Views
    3,040

    Thanks for suggestion but it is not posible...

    Thanks for suggestion but it is not posible because other users don't know to use the access.
  12. Answers
    10
    Views
    3,040

    I use excel 2010

    I use excel 2010
  13. Answers
    4
    Views
    729

    Can Pivot source be in more thatn 1 file

    Hi,

    I have an excel file of 135 MB for data of the year. I can break this as per monthly data but need to draw the singal pivot.

    Is it posible that I can creat a Pivot using more than 1 files....
  14. Answers
    10
    Views
    3,040

    How to manage 100+ MB excel file

    Hi,

    I have an excel file which is used as database of records for a year. As of now its size is 135MB and till Dec'12 I'll add data to this. But every time I open this file it takes too much time...
  15. Question: Period trouble

    by nikeshtnt
    Answers
    1
    Views
    316

    Yes u should go for checkup

    Yes u should go for checkup
  16. Answers
    1
    Views
    3,531

    How to create Index in MS Word 2010

    Hi,

    I have created a mannual in MS word and now want to make an index which should be linked so that just by clicking on index I can go to the page where details is written.

    Please suggest me...
  17. Answers
    2
    Views
    445

    I have checked it. Doesn't make any difference if...

    I have checked it. Doesn't make any difference if scroll lock is on or off
  18. Answers
    2
    Views
    445

    Excel Keys swaped

    Recently I started using excel 2007. From last week I am faceing following problem

    Problem No. 1
    Home and Ctr Home have been swapped

    E.g. If I am in Cell D6 then by pressing Home I should go...
  19. Excel 2007 shortcut key swaped & Up/Down key not working in edit mode

    Hi,

    Recently I started using excel 2007. From last week I am faceing following problem

    Problem No. 1
    Home and Ctr+Home have been swapped

    e.g. If I am in Cell D6 then by pressing Home I...
  20. Answers
    0
    Views
    410

    Too many different cell formats error

    Dear All,

    I have received an excel file which is firstly not opening properly. Most of the time it opens as repaired vr

    Please refer the attached doc file for actual massage.

    Even after...
  21. Answers
    1
    Views
    269

    Installation of Bluethooth Utiliti

    Dear All,

    I have Dell Insperion 6400 laptop. It has Bluetooth icon.

    When I tried to install the Bluetooth exe from its utilities CD it is showing an error

    Compatible chip is missing in your...
  22. Answers
    1
    Views
    574

    CD ROM/W not reading some disc

    Dear All,

    I have a Dell Insperian laptop. From last few months I facing some problem with CD Drive, it reads some CD while for others it just shows like some process is going on but that never...
  23. Answers
    3
    Views
    1,194

    Hi I have Apple Ipod and downloaded the itune...

    Hi

    I have Apple Ipod and downloaded the itune also. I can upload the audio files but not vedio files what to do.
    *** help
  24. Thanks JB it works

    Thanks JB it works
  25. Countif after checking two cumulative condition

    Hi Friends,

    I have a big list of Client list with start and end date. It gets changed every time and I need to prepare a summary movement report. I tried on formula but it gives #VALUE! As result....
  26. Question: Tax calculation

    by nikeshtnt
    Answers
    2
    Views
    837

    Since you are a salaried and purchased a house...

    Since you are a salaried and purchased a house which not in your work location, your calculation would be complicated and advise you to contact some tax consultant. B'cs you need to plan your tax...
  27. Answers
    2
    Views
    435

    UK Tax Calculation

    I am an Indian and my company is planning to send me UK on WP. I want to know that how tax workings are being done there and what type of benefit or obligation would be there.

    I will be paid some...
  28. Answers
    3
    Views
    474

    Thanks, I was using custom but with contain...

    Thanks,

    I was using custom but with contain but it wasn't worked.

    But why this happens only in few action because normally in filter drop down behave like this if there is a gap of some rows...
  29. Answers
    3
    Views
    474

    #N/A not showing in Filter

    Dear All,

    Sometimes I face this problem that #N/A doesn't show in the drop down of Filter function. It can be found by using Ctr+F.

    This problem exist even if the same file is being opened in...
  30. Answers
    3
    Views
    623

    Thanks JBequcaire, You have always helped me....

    Thanks JBequcaire,

    You have always helped me.

    I have this macro which I am using in some excel files. Is there any way I can get this macro available for all files so that I just go to...
  31. Answers
    3
    Views
    623

    Covertion of Number into Text

    Hi,

    Is there any formula by using that we can convert number into text e.g. 1523 One Thousand Five Hundred Twenty Three.

    I have got one i.e. BathText() but it's result is not in English.

    I...
  32. Answers
    2
    Views
    583

    Format an decimal as month

    How can 6.08 can be shown as 6 Yrs 1 Month and so on number of month would change like for 0.17 as 2, 0.25 as 3, 0.33 as 4...

    If condition is not working with Int() for more than 6 condition.
    ...
  33. Question: What to do

    by nikeshtnt
    Answers
    4
    Views
    422

    Thanks buddy actually I am trying everything to...

    Thanks buddy actually I am trying everything to make this relationship better and after posting my query here I have seen the improvement in her. May be because I am feeling bit relaxed now like...
  34. Question: What to do

    by nikeshtnt
    Answers
    4
    Views
    422

    What to do

    I am going to write what I have never shared with any one yet.. I have friends but all are like they know me as a good professional.

    I am from a middle class family born and brought up in a...
  35. Answers
    1
    Views
    492

    Move to creat new file

    I have prepared a payslip in excel and now I want to make separate file for each employee.

    I have list of employee with there Emp code and payslip which is linked with employee code through...
  36. Answers
    10
    Views
    8,311

    Thanks a ton!! It works perfectely fine.. ...

    Thanks a ton!!

    It works perfectely fine..

    Is it possible to put a password to see any data i.e. if any employee want to see his data then he need to enter his assign password.

    If yes then...
  37. Answers
    10
    Views
    8,311

    Hi JB.. good to here you again.. I would go...

    Hi JB.. good to here you again..

    I would go for without arrays because we work on systems which are very old & slow.
  38. Answers
    10
    Views
    8,311

    Great buddy... it works like bullet.. But I...

    Great buddy... it works like bullet..

    But I want to go one step furter.

    Now I have two sheets and want to get this filtered data in other sheet. I have attached again other sheet in this sheet...
  39. Answers
    10
    Views
    8,311

    Excel Filter Macro needed

    I have a list and want to filter it with reference to a cell. e.g. list is ranging from Row 5 to 2000, I want to assigne Cell A4 as reference to filter the data. When something is entered in A4 then...
  40. Answers
    2
    Views
    511

    Excel Forumla based on dates

    I am processing payment on monthly basis for employees based on per day entitlement. This entitlement changes from 91st day. So every month I get three set of employee

    1. Who have already...
  41. Question: Sex talk?

    by nikeshtnt
    Answers
    5
    Views
    567

    Gift some story books with nasty ones or give...

    Gift some story books with nasty ones or give some porn cd so that he should know that how broadminded you are. Touch his body and rub when you both are alone if rub your bumm on on his penis...
  42. Answers
    0
    Views
    2,136

    EMI Schedule with daily reducing method

    I am planning to take a home loan and talked to different banks. Some are offering with monthly reducing and some with daily reducing.

    This comes into effect if I do any pre-payment (partial)....
  43. Answers
    1
    Views
    3,860

    Data cleansing in excel

    Every day I get reports of more than thousand rows for data cleansing. In that report mainly we have to delete all the related records as per amount like +100 and -100 should be deleted.

    I have...
  44. Question: Name Separate

    by nikeshtnt
    Answers
    1
    Views
    674

    Name Separate

    I have a list of names and want to get that as first name, second name and third name.

    If there is two words are there in name then it should be taken as first name and third name, second name...
  45. Finding the given text in different columns and place in other column

    I have a worksheet where two columns contains name. I need to check that if one name is appering in any of these two columns then result shoule be shown in third column or if that name is not there...
  46. Answers
    4
    Views
    800

    I think the best solution for this would be using...

    I think the best solution for this would be using foumula in conditional formating. This would highlight all the values in a column appering more than once or as specified number in the formula.
    ...
  47. Answers
    5
    Views
    1,165

    Thanks a ton! It is a template so and as it is...

    Thanks a ton!

    It is a template so and as it is opening in excel is fine.

    Just a small question... Is there any do & don't in this file to run macro properly?
  48. Answers
    2
    Views
    1,748

    You can use the following macro and formula for...

    You can use the following macro and formula for this.

    Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)

    Dim rCell As Range

    Dim lCol As Long

    Dim vResult
  49. Answers
    5
    Views
    1,165

    Execl Validation

    I have created a Reimbursement claim form. In this form there are some information has to be filled and based on that some formula is there. I want that if some one fills this then he/she should not...
  50. Question: Execl links

    by nikeshtnt
    Answers
    1
    Views
    627

    Execl links

    I am working in finance and almost everything is in excel. I love using links and formulas for getting data from different files. But this creates problem also like now a days I am getting following...
Results 1 to 50 of 60