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

users
#1

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

#2

Hi :slight_smile:
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 :slight_smile:

#3

Hi :slight_smile:
Your email only got to me off-list but doesn't appear to have anything
confidential so i'm forwarding it back to the mailing list.
Annoyingly this mailing list now needs people to use "Reply to all" or
"Group Reply" rather than just "Reply" otherwise the list doesn't see
the responses and that means there is no-one to check on quality and
no-one else to jump in when they realise something useful worth
adding.

I've no idea about packages/programs designed for assessing insurance
values (errr, or whatever the task is for). Given my lack of
knowledge of the insurance industry i would go with GnuCash or i might
try to make a "relational database" in Base.

However since this is a "one off" task it might be easier to use
spreadsheets, this time. I think some sort of copy&pasting between
sheets or formulae such as (in cell A1 on sheet 3 (as an example);
=Sheet2.A1
to pull in the value from sheet 2. You might do some operations on
that figure or include it in a formula.

This guide might help you get to grips with spreadsheets
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide

Regards from
Tom :slight_smile:

#4

Thank You for your help!

#5

yes, this reply problem affect also me, I was used to press ctrl>R with thunderbird but now it's not so...:slight_smile: :slight_smile: :slight_smile: I didn't know it depends on list...:slight_smile: :slight_smile: :slight_smile: :slight_smile:

#6

As you can tell I'm new to spreadsheets and computers in general,
thanks in advance for your help and patience.

You want to use a relational database.

Sincerely,

Wolfgang