Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
newbie
Hello, I am a new assistant in my company. We are trying to organize information for easy access to employees. I currently have the Office 2007 Ultimate Suite. My sales department and fabrication manager only have Excel 2003, Word 2003, Power Point 2003, and Outlook 2003. My designer does not have any of these, (perhaps only Outlook 2000?). I would like to put information in one open accessible document per work order. My thought is to have all the information needed displayable in a browser. As in collecting and storing data, my team believes Excel should be the master file. (I am almost convinced that Access is more promising for our needs, yet I am the only one with the program which I think makes it difficult for others to view.) At this time we run a LAN with a mapped drive on each PC to a base folder on a desktop PC running Windows XP. We are researching a server and software within a tight budget but with the future in mind. Before we go further with purchasing this technology I must be able to have our current system function somewhat efficiently to persuade accounts payable how a server based system with whatever software will increase work flow. In the attempt to create this system I have been using the Online training. The Online training covers processes I am familiar with using and I am mathematically educated but connecting all my information has left me in a haze of data. So I ask you Microsoft , before sending me off to sales, what do I need to understand to have excel work in the following; Workbook A = [1 sheet total] Contacts contains first, last, addy, city, st, zip, ph., fax, mobile, email, category, & notes (?is it possible to make this some other database, outlook or access?) Workbook B = [##sheets total] work order project [Sheet1] Fields (same as contacts in workbook A) sales associate is allowed to enter first and/or last, then [query] button to workbook A = results~ if true then auto-fill remaining fields, if false :statement contact not listed in directory, please enter details [submit]button There are 4 contacts per order the remaining three would function as above with the option to check box same as #1 End = [Next] button [Sheet2] Number of objects , this is one cell for input, this qty creates # of additional cells below that drop down select [Object names] where each object name creates additional sheets Then master fields with drop down selection makes default for addition pages and qty is qty based on input from added sheets [Sheet3 (or 3+n)]- Printed document , where I link most previous data and need help with formula that =###.yy r## where ### =number +1 of previous workbooks (work orders) during year and r## = number resaves of workbook [Sheet4(or 4+n)] - time sheet totals that links to workbookC (daily time sheets) and workbookD (current and closed workorders) FINISH As you see I think I really need a better understanding of FORMS? And how to link input to finalization via open workbook or web input. I also think if I can make sense of this in Excel I will have a better understanding in Access later. Please guide me in the right direction. My knowledge is limited but not obstructed. Thank you. Sincerely, Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie needs help! | Excel Programming | |||
Newbie Help. Is this possible? | Excel Discussion (Misc queries) | |||
VBA newbie needs a little help | Excel Programming | |||
ADO newbie help please | Excel Programming |