Hi :) Sounds like you are designing a "relational database"!! An "off the peg" program made by someone else might be a MUCH easier way to get the results you want.
Is this for a web-site? If so there might be an option "e-commerce" plug-in that might make all this much easier. What are you using to build your website? Joomla/Drupal or WordPress or ...? If it's for a shop or for invoicing then you might like "GnuCash", kinda like Sage but it's a free accountancy/personal-finances package http://www.gnucash.org/ There are other Free programs that are more focused at one end of the scale or the other but GnuCash covers a reasonable range of "scale of enterprise". If you let us know whether it's for a computer in a shop or for "e-commerce" through a web-site then we might be able to suggest a few alternatives. Regard from Tom :) On 17 January 2014 19:28, Ed Konopki <[email protected]> wrote: > Help! > > I have created a spreadsheet which is basically a formula sheet for taking > wholesale items then adding profit/commission to it adding to it a per user > multiplier(50 different multipliers in all) to come to a retail number. > > > > Currently I have the formula which works perfectly fine, but > > . The different products are listed on their own spreadsheet - so I > have to go to that paper & get the product number and find the associated > price for that product and manually enter it in my formula spreadsheet > > . Then I have to go to a different spread sheet to find the zip code > for the user and the multiplier for that user and manually enter it in to my > formula sheet. > > > > Is there any way I can design the "Formula" spreadsheet to access > spreadsheet # 2 cell information and when I type in the user number the > spreadsheet will automatically insert the correct multiplier?? > > The same with spreadsheet #3 simply type in the zip code and bingo.in comes > the correct multiplier to my formula?? > > > > As you can tell I'm new to spreadsheets and computers in general, thanks in > advance for your help and patience. > > Ed > > > > > > > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
