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
Bookmarks