hey all i stumbled across this page through google and although i assume the macro i found might work if the information was all stored on one worksheet, but i have the information stored on a seperate page



inorder to clarify,

i have a workbook set up with 6 seperate worksheets inside it(11 columns, 71 rows with the possibility of eventually adding more later down the road)


the workbook is basically set up so that the 1st worksheet is the only one you have to edit the information on

then the 5 other worksheets are currently set to show the same information with the left most column changing to allow for easier locating of the information

if anyone is familiar with theater lighting this project is for insturment, color, channel etc hookups

my main problem is that i can use '=insturment!d3' to display the information but have no way to autosort and seeing as the cells are technically '=insturment!d3' i was unable to get this macro to work

if anyone can help me with this then it'd be a HUGE help to me, there is also a google spreadsheet here

or email me if you want a better explination

thanks