Search Results - VBForums

Search:

Type: Posts; User: ammu

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    614

    MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Hi vbfbryce,

    I hope you can help me on this please?

    Best Regards
    Ammu
  2. Replies
    6
    Views
    614

    MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Did any one get a chance to look at this? Please help me...
  3. Replies
    6
    Views
    614

    MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Dear All,

    Can someone please help me????? :(
  4. Replies
    6
    Views
    614

    MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Hi Pete,

    Could you please help me on this? please...
  5. Replies
    6
    Views
    614

    MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Can someone please help me on this?
  6. Replies
    6
    Views
    614

    MsOf10 Change Pivot Table & Pivot Chart through VBA

    Dear All,

    I have attached a sample file for your reference. In that file, I have three worksheets 1) Data 2) Chart and 3) Pivot.

    I have written a small code in "Chart" worksheet to change...
  7. MsOf10 Re: [RESOLVED] Data Validation should be added when the user enter a value in a range

    Thanks for the suggestion Pete. I will use select case. Thank you once again for all your help :)
  8. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    Thanks Pete. I tried something different and which worked fine. Here is the code




    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If PrevCell = "Rakesh" Or PrevCell =...
  9. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    Hi Pete,

    Thank you so much. I have removed my code (colored in blue) which is there in #12 and used this one. Thank you once again.

    One last help Pete. You can see in #12, I Have colored...
  10. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    There are only 8 names in the list
  11. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    Here is the code that I am using currently. Everything is working fine as expected, but there are two small things that need to be fixed.




    Dim prevCell As Range
    Dim PrevCell1 As Range

    ...
  12. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    No. No vbfbryce. I am using his code to fulfil my criteria 3 in question #1.

    Hi Pete,
    Thank you so much for all your support in the forum. You guys rock :)
  13. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    Excellent work vbfbryce. You're the best. I have no words to express my feelings. Thank you once again for your help:)
  14. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    Hi Vbfbryce,

    It is working very fine till row 39, users might insert more rows (between 8 to 39 rows) they insert 1 row or 10 rows at a time in that case it is not working and I am getting type...
  15. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    Hi vbfbryce,

    I have the following code which will help me up to some extent. Could you please help me to meet the specified criteria above?




    Private Sub Worksheet_Change(ByVal Target As...
  16. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    Can someone please help me on this?
  17. MsOf10 [RESOLVED] Data Validation should be added when the user enter a value in a range of cells

    Dear All,

    Currently I am using the following macro which is working fine only for one column.




    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Cell As Range
    If...
  18. MsOf10 View Post

    Yes. You're right vbfbryce. Conditional formatting is getting copied into other cells. This is what I wanted :)

    Thank you so much once again vbfbryce!!!
  19. MsOf10 View Post

    Great. Let me try this and let you know the results. Thank you so much for all your help vbfbryce
  20. MsOf10 View Post

    This looks great. But how do I copy to the below rows? If I copy the conditional formatting, then the formula values are not changing. For example if I want to copy the formula till 1000 rows...
  21. MsOf10 View Post

    This I already checked, but didn't help me
  22. MsOf10 View Post

    I have to use conditional format only and cannot use a macro for this
  23. MsOf10 View Post

    basically the blank cells in Column J are having 0.001 values. So for that entire row if you enter any value which is greater than 0, then column BD text should change to RED
  24. MsOf10 View Post

    If you select entire column J, you can see 0.001 values
  25. MsOf10 View Post

    Column J
  26. MsOf10 View Post

    I have a text in column BD that should change to red only if the above mentioned two conditions are met. I have also attached a sample worksheet for your reference. Please let me know if you need...
  27. MsOf10 View Post

    Is there anybody who can help me on this please?
  28. MsOf10 View Post

    Can someone please help me on this?
  29. MsOf10 View Post

    Dear All,

    I wated to change the format of the cells when the following two criterias are met 1) Cell value = 0.0001 and 2) Any of the following Cells...
  30. MsOf10 Re: [RESOLVED] [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Just wanted to know how do I post my code in a seperate window like the way you posted in previous posts 8 & 17 ? Please let me know. So that in my future posts I will also use those options.
  31. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Hi westconn1,

    I could able to fix all errors and it is working fine. All credit should go to you!!!!!

    Here is the final code below which is tested.

    Sub consolidation()

    Dim newb As...
  32. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    I have removed -6 from the below code, because if I keep -6 then it is not copying last six rows for every worksheet.

    If s = 0 Then rws = rws

    With this all rows being copied, but still at the...
  33. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    But I have several other problems that are mentioned below

    1) Column heading being copied only for 'Total Consolidation' sheet and for other two sheets heading is not being copied (Heading...
  34. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    I could able to find the mistake in the below lines. The correct code should be:

    "newb.sheets(shts(s)).Range("a1").Resize(, cols(s)).Value = wb.sheets(shts(s)).Range(heds(s)).Value"...
  35. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Dear Sir,

    I am getting the following error "Run-time error '1004' Application-defined or object defined error and highlighting the following line of code ...
  36. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Thank you so much Sir. I will check and get back to you.
  37. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Sorry it was my mistake I didn't mention in my previous thread.

    For "Total Consolidation" sheet it should copy from row A6 to K6 and till the last row where data exists
    for "State level...
  38. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Also in "Total Consolidation" sheet, it is taking 30 columns, but I need to take only A to K (11 columns) and in "District Level Consolidation" sheet I need to copy only 'O to AA' (columns 13)
  39. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    No. I have checked once again and all three worksheets names are correct and there is no mistake in the names, but still this error is coming
  40. MsOf10 Re: [MS Excel 2010] Consolidating all 55 workbooks into 1 new workbook

    Now I am getting Run-time error '9' script out of range and it is highlighting the following line "newb.Sheets(shts(s)).Range("a" & rw(s)).Resize(rws, cols).value = Wb.Sheets(s).UsedRange.value"
Results 1 to 40 of 76
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.