Merge excel spreadsheets

**ianma** · 03-12-2009, 05:26 AM

Hi all,

Am wondering if any of you can help me at all.

I currently have 7 members of staff in my team who all publish vacancies on a daily basis.

A way off kepping track off their work load we created a master spreadsheet with all the details like team member name, job title, location, pay scale, number of hires etc.
We have had some problems with the data getting over typed recently.

Am wondering is there anyway that if every team member has their own spreadsheet i could pull the data from their spreadsheets to the master spreadsheet on a daily basis? That way the master spreadsheet is not getting touched by the team members

Thanks in advance

**Cheeky Charlie** · 03-12-2009, 06:29 AM

But if they overtype their own workbooks it will upload to the master wrong with the same effect - or am I missing something?

CC

**ianma** · 03-12-2009, 06:39 AM

I can see where your coming from.

I think what is happening is they are overtyping the other team members data by mistake, i don't know how they keep doing it but its happening .
I've shared the document also but the data team members data is still getting over typed by others.

**Cheeky Charlie** · 03-12-2009, 08:23 AM

There are quite a few threads on the forum which might as well start "I work in a cage of trained monkeys, please help", it's quite nice to see it phrased so delicately.

The problem with this kind of things tends to be the variable size of the constituents - without VBA you end up with pretty long formulae to effect "put this value on the first empty cell in this table" - do you see what I mean? If you just reference areas you will end up with gaps in your master spreadsheet depending on how many free lines there are in the source, or missing info if there are two many lines.

This means VBA is more practical, but to help you with a solution along those lines we'd need to know more about the layout of the sheets. It would be possible to give each team member their own sheet in the same workbook but to hide the sheets which don't "belong" to that user - but this relies on everybody having VBA enabled (not default).

How comfortable are you with VBA and/or enabling macros for users?

**ianma** · 03-17-2009, 11:44 AM

Am useless with VBA

**mubashir aziz** · 03-18-2009, 05:02 AM

There is one way. You can Shared the work book and assign them one sheet with their name put password in each sheet and give password only the relevant person ...... link all these sheet in master sheet which will also be protected and only you knows the password ....... It it is confusing share your sheets, i'll try to dig it out ....