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?

Some thoughts on a possible approach/process

Let's say your receiving sheet is named: X

EOD-1 (EOD1=end-of-day1)
At EOD1, make a frozen copy* of X with the day's manual inputs - name this
sheet as: T
*Do an entire sheet copy n paste special as values on a new sheet

SOD-2 (SOD2=Start-of-day2)
At SOD-2, In X, the 4 cols would be refreshed ..
1. Clear the 2 input cols, then apply an index/match with error trap*,
matching on a key "id" col (this would be one of the 4 cols refreshed) to
extract the previous day's inputs from T, aligned to match the new,
refreshed 4 cols.
2. Freeze the formulated extracts (Select the 2 cols, do an "in-place" copy
n paste special as values)
3. Start the manual inputs for the day for the 2 cols
*Indicatively: =IF(ISNA(MATCH(...)),"",INDEX(..,MATCH(...)))

EOD-2 (EOD2=end-of-day2)
At EOD-2, make a frozen copy of X with the day's inputs, overwriting**
sheet: T
**Besides overwriting, you could of course retain each day's snapshot in
another "archive" file, naming these sheets suitably

Repeat process SOD-2 & EOD-2 on next working day, cycling it ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"popout" wrote in message
...
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?