easiest way to link front-end/back-end workbooks?

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,388
I have a large workbook into which 10 people are putting appointmnts on and off all day and they will need to leave the books open. They also use it view what appointments each other has added before adding their own.

Excel doesn't like shared multiple simultaneous users and I'm thinking I might have to use/learn access.

However, I wondered if this approach with excel is feasible.

Following the access approach of front end and back end databases, could I give each user a sheet to enter their data into and have one larger workbook compiling that data and turning it into reports they can view read-only? This larger workbook will also be used to compile and print timetables at the end of each week for the following week.

If so, what is the easiest way to bring that data from the individual data-entry sheets into the larger workbook? Is there a way to do this where the individual sheets don't need to be open? Is it as simple as referencing the smaller individual sheets' cells in the larger sheet?
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
your people can populate their own standalone spreadsheet and the master spreadsheet can pull in info, from that, if they look at the master before adding appointments they can avoid clashes....
 

Kyle123

Well-known Member
Joined
Jan 24, 2012
Messages
2,708
Use access, it's what it's for, don't try and hammer a square peg into a round hole ;) These things never really work smoothly - you'll have a much easier time of it using a database
 

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,388
...I just need to learn Access, then. That's my evening sorted out. :LOL:
 

Watch MrExcel Video

Forum statistics

Threads
1,109,030
Messages
5,526,344
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top