Hi,
I need to create a link to another spreadsheet(call it enter) (all on the G column) to this other almost identical spreadsheet(call it main) (also the G column). When people open this spreadsheet(enter) and edit it, I want it to send the edited data to my sheet(main) (this is based on a network) and when the information is changed(enter) (on the g column) I want that entire row's information to be copied to a spreadsheet that all of the other ones get sent to (new sheet). I know that it sounds complicated but if there is only a VB solution, can you tell me how to get that all working ( I mean the b-a-s-i-c-s!) Thanks heaps,
Carey
I need to create a link to another spreadsheet(call it enter) (all on the G column) to this other almost identical spreadsheet(call it main) (also the G column). When people open this spreadsheet(enter) and edit it, I want it to send the edited data to my sheet(main) (this is based on a network) and when the information is changed(enter) (on the g column) I want that entire row's information to be copied to a spreadsheet that all of the other ones get sent to (new sheet). I know that it sounds complicated but if there is only a VB solution, can you tell me how to get that all working ( I mean the b-a-s-i-c-s!) Thanks heaps,
Carey