- Aug 24, 2012
- 1,854
- 12
- 81
This is for work. Basically there is an issue regarding documentation discrepancies where one form says this but the other says something different and I've been asked to start keeping track of these issues.
Originally this was just a word document that described the problem along with pdfs of the referenced erroneous documents in a folder, and the folders were sorted by date and item numbers in the view tab.
But there are alot more of these problems than what I had originally thought and my folder is getting messy so I need a better way because it's getting hard to keep up with all.
Basically I need to able to sort these by date, item no, and customer in a spreadsheet file.
In this spreadsheet file I'd to also like be able to attach or link documents that I'm referencing in the spreadsheet.
I think there is a way to create a document entry form in excel but I don't remember for sure or whether that is still supported as the only one that I think I can recall seeing were pretty old (Win 2K era).
I suppose this could be done with sql but I know nothing about sql.
FWIW, My work uses Office 360 and I use Office 2010 at home.
What would be the best way to go about making this happen?
Originally this was just a word document that described the problem along with pdfs of the referenced erroneous documents in a folder, and the folders were sorted by date and item numbers in the view tab.
But there are alot more of these problems than what I had originally thought and my folder is getting messy so I need a better way because it's getting hard to keep up with all.
Basically I need to able to sort these by date, item no, and customer in a spreadsheet file.
In this spreadsheet file I'd to also like be able to attach or link documents that I'm referencing in the spreadsheet.
I think there is a way to create a document entry form in excel but I don't remember for sure or whether that is still supported as the only one that I think I can recall seeing were pretty old (Win 2K era).
I suppose this could be done with sql but I know nothing about sql.
FWIW, My work uses Office 360 and I use Office 2010 at home.
What would be the best way to go about making this happen?
Facebook
Twitter