MissRibena
08-04-2006, 01:46 PM
Not really sure if this is even the right site to post this, so sorry in advance if I'm getting on your nerves.
I have an excel spreadsheet that I use in a list form to track the status of open orders and provide a history for closed ones. I just use Autofilter to pull up whatever info I want. Because it's only me and my boss, I never had to really worry about someone over-writing the raw data. However, we're expanding and more and more people are relying on the information on my spreadsheet. Now we are using it as a mailmerge with Word for creating daily delivery notes, packing labels etc. This works fine but it's not very elegant and it's definitely not intuitive (and you get nasty DDE warnings when initialising the mailmerge doc and a link from the spreadsheet to initialise the word doc times out).
Is there a better way of doing it? I've thought about using excel to create the delivery notes, with macros and Vlookups to paste the data from the "main spreadsheet" for each individual order. It's do-able I think but a lot of work.
What do people usually do? Is this just the time to move the whole thing to Access? I'd gain a lot of flexibility with multiple tables and secruity but would need to set up queries etc to view the kind of info I now have at a glance in a spreadsheet.
Rebecca
I have an excel spreadsheet that I use in a list form to track the status of open orders and provide a history for closed ones. I just use Autofilter to pull up whatever info I want. Because it's only me and my boss, I never had to really worry about someone over-writing the raw data. However, we're expanding and more and more people are relying on the information on my spreadsheet. Now we are using it as a mailmerge with Word for creating daily delivery notes, packing labels etc. This works fine but it's not very elegant and it's definitely not intuitive (and you get nasty DDE warnings when initialising the mailmerge doc and a link from the spreadsheet to initialise the word doc times out).
Is there a better way of doing it? I've thought about using excel to create the delivery notes, with macros and Vlookups to paste the data from the "main spreadsheet" for each individual order. It's do-able I think but a lot of work.
What do people usually do? Is this just the time to move the whole thing to Access? I'd gain a lot of flexibility with multiple tables and secruity but would need to set up queries etc to view the kind of info I now have at a glance in a spreadsheet.
Rebecca