Quote:
Originally Posted by markis64
yeah access is cool if you know how to use it, it can get very difficult when you have a lot of tables, reports, quires etc...
i just finished using it in my computer and info tech class and it was by no means fun to learn but probably useful later on down the road.
for the excel situation maybe you could make a table withen your spreadsheet and hold certain things constant so you wont have to copy and paste so much? if im hearing you right? when you type in a formula like a vlookup formula it will just place the item from the table. Its probably a good idea to get a book like excel for dummies it has all the formulas and directions youll ever need, because its way to hard to ask people how to when it comes to that kind of stuff sometimes
|
I see 2 options:
1) switch to MS Access.
2) use macros in Excel.
Either way you have a learning curve but it will beat copy/paste on the long run.