Re: Compare Pivot Tables
Hi Dave,
Thanks for the response, I made a pivot and copy pasted the values, since the file size was big.Is it possible to compare it.
Re: Compare Pivot Tables
Hi Dave,
Thanks for the response, I made a pivot and copy pasted the values, since the file size was big.Is it possible to compare it.
Hi,
Is it possible for me to compare two pivot tables and get a report. in the attached example, is it possible to compare sheet1 and sheet 2, if the values haven't changed, then it should be green, or it should be red. Could somebody help me with this please.
Re: Sort Based On Two Independent Cells
Hi face2face,
I didn't get the updated file. could you attach that please.
Re: Sort Based On Two Independent Cells
Thanks a ton face2face...
But, a small problem, i am not able to find out why. The Macro brings up an error when i put this data set. Could you advise on the same please. Sorry for taking up your time.
Re: Sort Based On Two Independent Cells
Hi face2face,
If you see the attached sample2, the area highlighted in green, it is fine. But the ones highlighted in Red shouldn't have been there as per the criteria
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...
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....
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.
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
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....
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
Re: Dynamic Userform
Oops Sorry....
I didn't
It works fine Now Thanks
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...
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.....
Re: Copy Paste Rows To Another Sheet Based On Column Criteria
Hi mtv20,
i am really sorry that i am bothering you too much....
The Code is only working for the first row and the data in the second sheet gets overwritten.. I want the lines to add on to the second sheet...
Re: Copy Rows From One Sheet And Paste It In Another Sheet Based On A Column Criteria
Thanks for the help...
But i would also like the data copied to be deleted from the data sheet.
Hi,
Need your help with this one!!!
I have a file that has two sheets, I have some formulas in the first sheet named "Data",What i would like to have is, If column G in the sheet Data is "Closed", then i want that particular row to be cut from the sheet " Data" and pated in to the Sheet "Done".Is this possible.... Please Help!!!!
Hi All,
I have a tracker where the activities done by a person in a single day is captured.I have a VBA code which captures the time without allowing a person to enter it manually.But, still the person can copy a time from an other cell and paste it here.Can this be restricted so that the date once captured cannot be changed by anybody other than the administrator.
Re: Add Static Date & Time To Cell
That works Great Dave.
Thanks a lot....
Re: Add Static Date & Time To Cell
Is there a way to activate a VBA to capture time, if a value is entered in the previous cell.