Hello, I submitted a post the other day, I was wondering if any one
experienced could give me some advice on automatic sorting. I have two sheets
that are linked together by the last column when the number in the last
column changes everyday with new information pasted into sheet two the
numbers are either higher or lower. In order to keep the positions in from
highest to lowest, the ideal situation for this database is to have the sheet
automatically sort when that last column changes. changes made from J6 - J40
(last column) and when that changes entire row (stock ticker stock etc) needs
to be sorted as well. Is that an "if" function. I tried to add a code (right
click on sheet 1) and view code and entered what I was told but it hasnt work

This was my first discussion group message abotu this topic:
"I currently am working on a excel spreadsheet that needs to be a working
database. It is currently linked to bloomberg, (stock prices are
automatically fed and updated) (live feed) The only column that will change
everyday is the last one, although when the last one changes the positions of
the stocks need to be sorted based on that last column in ascending order.
can anyone assist me with this. I am on a deadline and have been working on
this project for the last week, not which direction i should be going with
this."



Thank you in advance!!