Sorting in Excel

[daveallston]

Hi
Quick question, hopefully my last one for this project.

If I have a sheet within a book, that pulls one line of data from other
sheets in the same book, is it possible to sort these lines within that
one sheet? Would I need a macro for such a task?

If that doesn't make sense, what i mean is that I am pulling one line
of data from each tab, the "total" line of each. Then on one tab is the
summarative table of each of these totals lines from the individual
tabs. I can of course, present them in their pulled state, but they are
not sorted. Can someone please let me know how I can build in the sort
in that summerative table, once the data is pulled from the other
sheets?

Thanks for your help!
(e-mail address removed)

 

[Bruno]

It is possible to use regular excel sort, just present this results in
row! The references will remain intact but he results will be sorted.
Bruno.