Posts by salimthaj

  • Sort Based On Two Independent Cells

    Re: Sort Based On Two Independent Cells


    Dear face2face,


    This is fine, but need a small favour too... If you see the way the macro works, whenever a value in "F" is chosen as the highest, the corresponding "D" values move one step down and the values corresponding to "D" in that particular row are empty. but the same doesn't happen the other way around. When D has the higher value the corresponding values of F are not empty. Could you fix this please...


    Thanks a ton for your help...

  • Sort Based On Two Independent Cells

    Re: Sort Based On Two Independent Cells


    Hi Fredrick,
    In the attached example, the area highlighted in green is the raw data and the one in yellow is the finished data. In raw data, first compare the cells D3 & F3, Since they are equal, we leave them as it is, Now compare the cells D4 & F4, Since D4 is less than F4, we pull the data corresponding to D4 by a step down,which is shown in row 12.Now D12 & F12 becomes equal and so we go to the next row and henceforth....

  • Sort Based On Two Independent Cells

    Re: Sort Based On Two Independend Cells


    Hi face2face,


    If you compare the cells D4 and F4, F4 is greater than D4, that is the reason why the corresponding values to D4 are brought a step down.Now, we will compare D5 with F5, since the values are the same. No change here. Hope i answered your question.

  • Sort Based On Two Independent Cells

    Dear All,


    Need your help in fixing this.


    In the attached spread sheet, i have two set of data, for two different months.Columns A to D have the value for the first month and columns F to I have the values for the second month. In the first set of Values i have the dollar value in the column "D" and in the second set of values i have the dollar value in column "F". I want a macro, to compare these two cells and arrange the data accordingly. If both the values are the same, then both the lines corresponding to the values can remain in the same row. If one value is greater that other, then the set of values which have the lower dollar value should come to the next row. I have attachec the sample data. The lines highlighted in green is the raw data and the one in yellow is the finished data.


    Is this workable???


    Can Somebody Help....


    Thank You

  • Start A New Application

    Re: Start A New Application


    Thanks for the help...


    But there is a Small problem....


    The Code given for Shell opens a new excel application while the userform is opened in the existing application, as a result i still am not able to work on the other excel files that were open already. The New excel application only has a new file....

  • Start A New Application

    Hi All,


    I have an excel file which automatically loads an user form once the file is opened and when the user form is closed, the file also closes. When the file is open i am not able to switch to anyother excel file because this userform is active. Is there a way, when i open the file with userform, a New excel application starts. So that i can use the other excel files opened by the previous excel application.


    Thanks

  • Dynamic Userform

    Re: Dynamic Userform


    Thanks a ton ACW and BILL,


    Great Help.... But a Small Problem, My part number is not a numeric value it is always DV/01077/0038.


    The Above code is not helping... is there a way out for this....


    Thanks a lot for your help in Advance...

  • Dynamic Userform

    Hi All,


    Need your help with this one....


    I am not Sure whether this can be done or not... Please help...


    I have an excel sheet where i have the part number in the Column "A". I have four sets of four columns each which has the details of price for that particular part, currency , lead time and the Vendor Name. Now i want to have an user form where in i can put in the details of a part number and i should get the details of the best vendor in terms of price and lead time Seperately. The best vendor in terms of price is determined by comparing the values in the columns B, F, J & N and The best vendor in terms of leadtime is determined by comparing the values in the columns D, H, L & P. I have also created an user form with out any code just to give you an idea of what i am looking at. So that it can be helpful to you. I just key in the part code and i get the best results for the same. Is this possible.... Please help.....