Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Search For:

Type: Posts; User: rksample

Page 1 of 3 1 2 3

Search For: Search took 0.01 seconds.

  1. Replies
    2
    Views
    402

    Re: VBA Help with Task Allocation Macro

    Hi All,

    I didn't get any response even after 24 hrs. So I modified the description for better understanding.

    Eagerly waiting for a lead on how to do this.

    Thank you,

    cheers,
    Ravi.
  2. Replies
    2
    Views
    402

    VBA Help with Task Allocation Macro

    Hi Excel Gurus,

    I need help with a small VBA logic that can loop through a set of tasks and assign Employees to the tasks.

    Process:


    I have a set of tasks (Task 1 to Task 10)
    I have 3...
  3. Matching if a value is present in a Array

    Hi Gurus,

    Quick help with an array related VBA problem. I have a table with information on what classes are assigned to a Teacher.

    Classes Teacher
    1 Ravi
    2 Kiran
    3 ...
  4. Re: Copy table values to Array variables and use them in another sheet!

    Thank you very much Nicolas. This is very helpful. I learnt the lesson needed. I hope I'll be able to apply it now.

    Regards,
    Ravi Kiran.
  5. Copy table values to Array variables and use them in another sheet!

    Hi Gurus,

    I have a query about using Array Variables in excel VBA. I have a set of lookup tables and a main data table. The data table will be downloaded everyday. I need to replace the ID's in...
  6. Replies
    5
    Views
    366

    Re: Chart for Top 3 values

    Thank you very much Stephen! I tried understanding the formula :( but no use. Though I am able to adapt it to my table :)

    If you got some time, can you please explain how the formula works.
    ...
  7. Replies
    5
    Views
    366

    Re: Chart for Top 3 values

    Thanks for you reply Stephen.

    That would be ideal. But I will be satisfied with 3 values supposed to be topped the whole list. I spent considerable amount of time modelling the table. But am stuck...
  8. Replies
    5
    Views
    366

    Chart for Top 3 values

    Dear Gurus,

    I need to create a chart from a table with the Top 3 values in the series.

    Please find the info in the below image.

    48226

    So when Class 1 is selected, the values in the Table...
  9. Re: Search for duplicate records in a selection

    Thanks Jindon, this code worked awesome. Thanks again.

    Regards,
    RK.
  10. Re: Search for duplicate records in a selection

    Thanks Jindon. I am checking out to customize the code.

    There are few titbits I didn't understand. What is "Scripting.Dictionary"?

    And where do I copy my script to extract the relevant data (if...
  11. Search for duplicate records in a selection

    I run a script in a loop for several records (Orders). The loop works fine. But the problem is, sometimes there are duplicates. Processing time for each record is high and having duplicates is...
  12. Replies
    3
    Views
    366

    Re: Separate Top 4 Values a list

    Thanks. But I need two formulas. One to copy the Values and another to copy the respective vendors as well :)

    I'll try to figure out. But would be helpful, if you can post the solution.
    ...
  13. Replies
    3
    Views
    366

    Separate Top 4 Values a list

    Dear Gurus,

    Need some help with this issue. I have a list of vendors who enter their sales data in an excel spread sheet. I need to isolate the top four and create a separate list using excel...
  14. Replies
    3
    Views
    345

    Re: Text to Date conversion issues

    I do use European Date system. And the time&date settings are correctly configured to UK on my system. I did trouble shoot that.

    There must me some other explanation, why the date is being...
  15. Replies
    3
    Views
    345

    Text to Date conversion issues

    Dear Gurus,

    I have a problem converting a column containing datetime values as text.

    ="06/07/2012 00:00:00"
    ="06/07/2012 00:05:00"
    ="06/07/2012 00:07:00"
    ="06/07/2012 00:09:00"
    ="06/07/2012...
  16. Replies
    1
    Views
    429

    Extract data from open web page

    Dear Gurus,

    I need help from an MSDN Guru :) My question is: Is there a way to point excel to an open webpage and it extracts the required data from the page?

    Detailed explanation:

    My client...
  17. Re: Compare Sample Timings between multiple records

    Bump!

    Guys, can anyone help me with the VBA Code for this?

    Thanks,

    Regards,
    RK.
  18. Re: Compare Sample Timings between multiple records

    Sorry NBVC, this doesn't work forme.

    I am not sure formula approach will work for me. I am looking out to write a VBA code for this feature.

    Any assistance with this code will be of great...
  19. Compare Sample Timings between multiple records

    Dear Gurus,

    I have a complex issue to be solved (complex enough for me at this moment) :)

    I have a list of records with Date and Time, from this we need to scan through the time and pick those...
  20. Replies
    1
    Views
    322

    Conditional Formatting and VBA

    Dear Gurus,

    I need to reference a cell and conditionally format another cell. There are 3 conditions that I need to apply. I have some problem with the syntax, esp, where I need to refer if text...
  21. Re: VBA Macro Code To Copy Multiple Cells & Paste As a Continuous Range

    Thanks for the help. I got it working.

    Regards,
    RK.
  22. Re: VBA Macro Code To Copy Multiple Cells & Paste As a Continuous Range

    Thanks Jindon. That's helpful. But the issue is I am unable to use dynamic rows in that syntax :)

    Can you help me with that as well taking the active row as cRow?

    Thank you,

    Regards,
    RK.
  23. Re: VBA Macro Code To Copy Multiple Cells & Paste As a Continuous Range

    Dear Michael,

    Let me clarify my position.

    I am trying to copy data from 1 huge table and create few table based on different criteria. The problem is that the initial table is huge (1000s of...
  24. VBA Macro Code To Copy Multiple Cells & Paste As a Continuous Range

    Hello Friends,

    I have this weird requirement in VBA, where I need to copy multiple sections of a range (single row), but need to paste it as a continuous range. I mean the following e.g.:


    ...
  25. Replies
    2
    Views
    1,055

    Re: Excel VBA Blank Error

    Thanks Cytop. I exactly followed the instructions. Hope the issue gets fixed :) Thanks very much.

    Regards,
    RK.
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno