| View previous topic :: View next topic |
| Author |
Message |
kinathrus
Newbie
Joined: 25 Jul 2009
Posts: 2
Location: Australia
|
 Posted: Sat Jul 25, 2009 2:53 am Post subject: Newbie needs help with list boxes..... |
 |
|
Hello people, I have a problem that's been bugging me for a while now, hope you can help.
Basicaly I have a Worksheet that has 4 sheets in it, what I want to be able to do is have a
series of listboxes or something similar where I can select an entire row from each sheet
( 1 per box ), so that I can apply functions to the data. eg:
sheet 4:
box1 - sh1 row2 1 4 6
box2 - sh2 row6 4 12 9
box3 - sh3 row12 7 3 0
function sum all 12 19 15
Is this even possible in calc? If so any help would be deeply appreciated.
P.S. I have absolutely no experience with macros..... |
|
| Back to top |
|
 |
kinathrus
Newbie
Joined: 25 Jul 2009
Posts: 2
Location: Australia
|
| Posted: Sat Jul 25, 2009 4:12 pm Post subject: |
|
|
Thanks for nothing guys, got it to work using a list box and vlookup.
Minor problem, why do some entries give the #N/A error? |
|
| Back to top |
|
|
|
