Right.

What is the easiest and quickest way to link 2 spreadsheets together to form a master spreadsheet.

I have an excel spreadsheet that I enter info onto everyday. A colleague of mine has a similar spreadsheet that he updates everyday. We want to be able to continue to have our own individual files but for all the information to automatically go onto a master file that contains both sets of data.

Our individual spreadsheets are identical in every way.(apart from the data obviously)

I suggested we start using Access instead, even offered to set it up with forms and sql queries but was refbuffed. Never paid much attention to excel basics, I hate the prog but any quick solutions would be appreciated.

Cheers Cocks.

Report this post to a moderator | IP: Logged

Do you just want to total each cell? So your A1 plus his/her A1? Can you open both spreadsheets on one pc?

If so the just open both spreadsheets, open a new workbook and in A1 type = then click A1 in your spreadsheet, press '+' then click A1 in his/her spreadsheet.

::EDIT::
But as you obviously know - Access would be the best way to go. If you've got the time to do it then I would do. When they see it they will probably prefer it.

Last edited by Linnets on 01-07-2009 at 07:44 PM

Report this post to a moderator | IP: Logged

I've attached a quick example.

Attachment: spreadsheet example.zip
This has been downloaded 8 time(s).

Report this post to a moderator | IP: Logged

No I don't want just the total.

I want all the data from both spreadsheets shown in 1 big spreadsheet. Everytime I add data to my spreadsheet and save it, I want that exact data saved to the big spreadsheet and the same for when the other guy saves his.

Report this post to a moderator | IP: Logged

Like this

Attachment: spreadsheets.zip
This has been downloaded 6 time(s).

Report this post to a moderator | IP: Logged

I'd probably do it by running a macro every time the joint file opens. ALthough I would have to do some investigation into how to do that anyway. You would think it would be VERY easy but there is one difficulty in that cursor movements return absolute cell values when you record a macro. So when you push ctrl + down cursor to get to the end of a column, in the macro it records the cell value (A89 for example) rather than recording the keystroke ctrl + down cursor. If you get my meaning. I know there are ways of doing it in VBA because I've done it before at work, but I can't remember what it is now, and I'm a mac which can't use VBA here so I can't help further.

Use an Access database.

Report this post to a moderator | IP: Logged

quote:

---

Originally posted by Linnets

Use an Access database.

---

Report this post to a moderator | IP: Logged

export to access and stop using excel if it's continous data drunks x

Report this post to a moderator | IP: Logged

ACCESS IS NOT AN OPTION

Report this post to a moderator | IP: Logged

What about Access?

Report this post to a moderator | IP: Logged

What's Access?

Report this post to a moderator | IP: Logged

Right. Well the only solution I can see is to make a form in VB. Enter data into form and then on clicking the save button in that form all that data gets saved to both my spreadsheet and to the master spreadsheet. Would have to be saved after every individual entry and a slightly different form would be needed for my colleague.

Now to dust off my VB books, its got to be simple as fuck.

Report this post to a moderator | IP: Logged