sort required
I have a worksheet with 6 columns, 4 of which receive data via an indirect
function fron another open worksheet (i don't know the formula for indirect
function with closed worksheet!).The other 2 columns are manual input and not
referenced.
The problem is, the 4 columns from the source worksheet are continuously
being sorted, acording to usage.
My 'receiving 'worksheet follows the sort for the 4 columns, but it results
in the manual input data in the other 2 columns being in the wrong place
(i.e. not subject to the same sort)
I have a headache trying to find function,formula to get all columns to
follow. I cannot use a macro/vba because i don't know how to.
Any help out there?
|