Linking sheets-any help?

[ryan01]

Hi

Me again... I am a teacher and am doing my marks on excel, no surprise...

However, the school where I work doesn't have an open source system to type marks in and send them to reports. We type our own reports.

I have made the reports on excel and am in the process of linking each sheet with the report so that it carries over the marks.

My question is:

Surely there is a less time consuming method of linking one cell at a time. I know I can copy and paste the link after linking a couple of cells and then just changing the link extension to match the other cells. But if I have 35 kids in a class and there are 9 subjects-that takes a while.

I don't know vb so I don't know if there would be a code I could write to link them.

Just an amateur trying to make life a little less complicated.

Thanks

 

[CWatts]

Well it depends. I don't know if I understand completely or not, but are you talking about linking sheet to sheet in the same file, or to a different file?

If you' link to a separate file, it will put $'s in you cell reference, those lock them and wont let you copy and paste them down. For example, if you link the first cell, remove the $ symbols. In the bottom right of your cell, there is a tiny black dot. When you mouse-over it, you'll notice your cursor changes from a fat white cursor to a small black cursor, you can then drag it down.

I'm assuming each subject is on a separate tab, so if your cell references "Math" you can do a find/replace and replace "Math" with "History".

If that doesn't do what you need could you provide a little more detail?