Is it possible to create a macro whereby when data is entered into sheet 1 it is duplicated into sheet 2 and ranked from highest to lowest.
It should be ranked based on the 'Bid' column.
Attached is a test file.
Is it possible to create a macro whereby when data is entered into sheet 1 it is duplicated into sheet 2 and ranked from highest to lowest.
It should be ranked based on the 'Bid' column.
Attached is a test file.
Shall do the jobPlease Login or Register to view this content.
Best Regards,
Kaper
Really appreciate the effort.
Just to confuse things a little more. Would it be possible to do the same but 'Sheet 1' was in this format.
Understandably it would be more difficult as the formats are not the same.
Really appreciate the effort.
Just to confuse things a little more. Would it be possible to do the same but 'Sheet 1' was in this format.
Understandably it would be more difficult as the formats are not the same.
Copying and PastingSpecial of transposed data is needed. For instance:
Please Login or Register to view this content.
Thanks so much for the assistance. Works perfectly. My only query now is whether data can automatically update in sheet 2 when figures in sheet 1 are added.
At the moment not. You shall run the macro again.
Easy way to do it is to call it every time some values are entered in sheet A.
But just to consider - if one runs macro for larger set of data probably some 0.5 may be 1 second delay is not a problem. but if it happens every time you enter a new value - could be annoying.
Anyway - worth trying, may be delay will be shorter (and acceptable).
So in Sheet1 code (not in general module):
And to make sure "old data" is cleared one may add one line just below With Sheets("Sheet2"):Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks