Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Sort Gantt - Help required | Charts and Charting in Excel | |||
Some sort of lookup formula required | Excel Worksheet Functions | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |