Re: [libreoffice-users] (libreoffice-users) access data fron 2nd spreadsheet to use on 1st spreadsheet

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 <eddort@ptd.net> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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