LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort function for dates does not sort properly in Office 2007 Exc. Rosalie Excel Worksheet Functions 1 November 22nd 07 10:25 PM
Sort Gantt - Help required Mutiple grouped Gantt charts in Excel Charts and Charting in Excel 1 February 10th 07 09:45 PM
Some sort of lookup formula required Syndrome Excel Worksheet Functions 7 November 27th 06 08:36 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"