Search Results - VBForums

Search:

Type: Posts; User: ammu

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. MsOf10 Re: Need a VBA Macro to re-arrange the Data in a specified format

    I also request you and forum members to help me understand the VBA concepts step by step in a easy way (any links etc). Please help me guys. I am interested in learning, but since I don't...
  2. MsOf10 Re: Need a VBA Macro to re-arrange the Data in a specified format

    Thanks for responding to my thread vbfbryce. I am a commerce graduate and don't have much knowledge about VBA macros, but I tried several times and wasn't able to understand VBA concepts.

    At...
  3. MsOf10 Re: Need a VBA Macro to re-arrange the Data in a specified format

    Dear All,

    Can someone please help me with the code?
  4. MsOf10 Need a VBA Macro to re-arrange the Data in a specified format

    Dear All,

    I have two worksheets in the attachment.

    One sheet contains Raw-Data
    Another sheet contains data re-arranged in a different format.

    Is it possible to build a macro to use data...
  5. Re: I am not able to see all threads in Office Development it is just showing only 55

    Now I can see it. Thank you so much Pete :)
  6. [RESOLVED] I am not able to see all threads in Office Development it is just showing only 55

    Dear All,

    Just wanted to know is there a way see old threads in Office Development? In the main screen it shows that there are totally 19,917 threads, but after entering into the Office...
  7. MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Hi vbfbryce,

    I hope you can help me on this please?

    Best Regards
    Ammu
  8. MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Did any one get a chance to look at this? Please help me...
  9. MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Dear All,

    Can someone please help me????? :(
  10. MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Hi Pete,

    Could you please help me on this? please...
  11. MsOf10 Re: Change Pivot Table & Pivot Chart through VBA

    Can someone please help me on this?
  12. MsOf10 [RESOLVED] 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...
  13. 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 :)
  14. 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 =...
  15. 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...
  16. 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
  17. 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

    ...
  18. 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 :)
  19. 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:)
  20. 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...
  21. 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...
  22. 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?
  23. 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...
  24. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    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!!!
  25. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    Great. Let me try this and let you know the results. Thank you so much for all your help vbfbryce
  26. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    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...
  27. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    This I already checked, but didn't help me
  28. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    I have to use conditional format only and cannot use a macro for this
  29. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    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
  30. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    If you select entire column J, you can see 0.001 values
  31. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    Column J
  32. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    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...
  33. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    Is there anybody who can help me on this please?
  34. MsOf10 Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    Can someone please help me on this?
  35. MsOf10 [RESOLVED] [MS EXCEL 2010] Conditional formatting based on two Criteria’s

    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...
  36. 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.
  37. 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...
  38. 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...
  39. 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...
  40. 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"...
Results 1 to 40 of 82
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.