Tracking Sheet

[counihan3]

I want to build a spreadsheet so that I can track orders, just really basic information for some trend analysis. The problem is that I want it all to be contained in one spreadsheet, but I will have multiple people working on it at the same time. Is this possible?

 

[VoG]

You could use a shared workbook - see http://office.microsoft.com/en-us/excel/HA010130571033.aspx

 

[counihan3]

Will it interact with a macro with out any problems.

 

[VoG]

You can use existing macros (i.e. written before you make the workbook shared). Here's what you can't do with a shared workbook http://office.microsoft.com/en-us/excel/HP052010801033.aspx

 

[counihan3]

Thanks VoG that was really helpful. I think that I now need to figure out how to use access for this project and I have no idea how.

 

[VoG]

I think that I now need to figure out how to use access for this project and I have no idea how.

I can't help with that - I'm an Access moron

Try asking in the Access forum.