Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Spreadsheet guru needed

  1. 27th September 2017, 03:50 PM #1
    onebob's Avatar
    onebob
    onebob is offline Wizard Supporter
    Join Date
    Jan 2011
    Location
    Gippsland
    Posts
    1,508
    Total Downloaded
    0

    Spreadsheet guru needed

    I am not skilled at writing formulas and would welcome some help. What i want to be able do is enter a number into say C5 and have that number populated to say 20 other scattered cells in the matrix i will create..
    Can it be done ??
    LROCV member #131
    1999 build D2 TD5 Auto, Mantec snorkel, 2" LRA spring lift, ARB on board air, Ashcroft ATB, CMM air ram CDL shifter, swag & gold pans ....
    Reply With Quote Reply With Quote
  2. 27th September 2017, 04:05 PM #2
    Classic88
    Classic88 is offline Master
    Join Date
    May 2017
    Location
    Sydney
    Posts
    233
    Total Downloaded
    0
    Quote Originally Posted by onebob View Post
    I am not skilled at writing formulas and would welcome some help. What i want to be able do is enter a number into say C5 and have that number populated to say 20 other scattered cells in the matrix i will create..
    Can it be done ??
    I think a simple "=C5" in the destination cells should do the trick.
    Reply With Quote Reply With Quote
  3. 27th September 2017, 04:20 PM #3
    onebob's Avatar
    onebob
    onebob is offline Wizard Supporter
    Join Date
    Jan 2011
    Location
    Gippsland
    Posts
    1,508
    Total Downloaded
    0
    Sadly no.....Spreadsheet guru neededsays that formula cannot reference.
    LROCV member #131
    1999 build D2 TD5 Auto, Mantec snorkel, 2" LRA spring lift, ARB on board air, Ashcroft ATB, CMM air ram CDL shifter, swag & gold pans ....
    Reply With Quote Reply With Quote
  4. 27th September 2017, 04:23 PM #4
    dirvine's Avatar
    dirvine
    dirvine is offline Master Supporter
    Join Date
    Aug 2016
    Location
    Melbourne
    Posts
    521
    Total Downloaded
    0
    Try =+C5. Although =C5 works for me.
    2016.5 TDV6 Graphite D4,Corris Grey,APT sliders,Goe air comp plate,UHF & HF radio,Airflow snorkel,Discrete Winch,Compo rims with 265/65/18 Wildpeak AT3W, LLAMs,Traxide dual battery,EAS emergency kit,Mitch Hitch EGR blank & delete,ECU remap
    Reply With Quote Reply With Quote
  5. 27th September 2017, 04:36 PM #5
    p38arover's Avatar
    p38arover
    p38arover is offline Major part of the heart and soul of AULRO.com
    Administrator
    I'm here to help you!     Gold Subscriber
    Join Date
    Jan 1970
    Location
    Western Sydney
    Posts
    30,704
    Total Downloaded
    1.63 MB
    Quote Originally Posted by onebob View Post
    Sadly no.....Spreadsheet guru neededsays that formula cannot reference.
    It should work (I just tested it). Did you leave out the quotes? Is C5 in the same spreadsheet?
    Ron B.
    VK2OTC

    2003 L322 Range Rover Vogue 4.4 V8 Auto
    2007 Yamaha XJR1300
    Previous: 1983, 1986 RRC; 1995, 1996 P38A; 1995 Disco1; 1984 V8 County 110; Series IIA



    RIP Bucko - Riding on Forever
    Reply With Quote Reply With Quote
  6. 27th September 2017, 04:44 PM #6
    onebob's Avatar
    onebob
    onebob is offline Wizard Supporter
    Join Date
    Jan 2011
    Location
    Gippsland
    Posts
    1,508
    Total Downloaded
    0
    Yup, left out the quotes. Shoulda said up front that i'm not using excel but Apple Numbers. I have used excel formula's before as a guide to successfully build a lottery checker in Numbers. So if =C5 works in excel then i need to tinker a bit more i guess...
    LROCV member #131
    1999 build D2 TD5 Auto, Mantec snorkel, 2" LRA spring lift, ARB on board air, Ashcroft ATB, CMM air ram CDL shifter, swag & gold pans ....
    Reply With Quote Reply With Quote
  7. 27th September 2017, 04:59 PM #7
    onebob's Avatar
    onebob
    onebob is offline Wizard Supporter
    Join Date
    Jan 2011
    Location
    Gippsland
    Posts
    1,508
    Total Downloaded
    0

    Spreadsheet guru needed

    It's got something to do with setting the cell reference ie sum or product or the like.... I just tried product but no joy Spreadsheet guru needed
    LROCV member #131
    1999 build D2 TD5 Auto, Mantec snorkel, 2" LRA spring lift, ARB on board air, Ashcroft ATB, CMM air ram CDL shifter, swag & gold pans ....
    Reply With Quote Reply With Quote
  8. 27th September 2017, 05:44 PM #8
    Tombie Guest
    Bob are you willing to send me your sheet?
    Reply With Quote Reply With Quote
  9. 27th September 2017, 05:53 PM #9
    Tombie Guest

    Demo sheet works...

    Bob this sheet works....

    just a hack to test linking etc.. Download it and change extension from .xlsx to .numbers as this forum wont allow a numbers file format.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  10. 28th September 2017, 06:50 AM #10
    onebob's Avatar
    onebob
    onebob is offline Wizard Supporter
    Join Date
    Jan 2011
    Location
    Gippsland
    Posts
    1,508
    Total Downloaded
    0
    Thanks a million Tombie, i have downloaded it and will have look sometime today Spreadsheet guru needed
    LROCV member #131
    1999 build D2 TD5 Auto, Mantec snorkel, 2" LRA spring lift, ARB on board air, Ashcroft ATB, CMM air ram CDL shifter, swag & gold pans ....
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« Photobucket | Australia to form national space agency »

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Search AULRO.com ONLY!
 Search All the Web!