Spreadsheet Help?

Go down

Spreadsheet Help? Empty Spreadsheet Help?

Post by Free Jack on Sat Dec 13, 2008 9:30 am

had no idea where to put this and it is only a quick question. I want to make a googledoc spreadsheet which is just just a section from another googledoc spreadsheet, so than when stuff is changed on the originial it will appear on the new spreadsheet i am trying to make. I think i found the right formula but not sure how to use it, the insertrange forumla = =ImportRange(spreadsheet_key, sheet!range). Is That right and how do i use it?
Free Jack
Free Jack

Number of posts : 1225
Age : 26
eLocation : eNottingham
E-rep function: : UYA owner, PCP member, Congressman (2nd Term), MoD apprentice
Registration date : 2008-04-06

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Deilos on Sat Dec 13, 2008 9:37 am

No idea, but I do know that you can just add another page to a spreadsheet that already exists and put a formula in the part which you want to be dependent, then it will change as the other changes. See: paratrooper roster, the total number of paras at the end page changes when the totals of each platoon page changes.
Deilos
Deilos

Number of posts : 2613
Age : 26
eLocation : North West
E-rep function: : Lord, Battle Monkey
Registration date : 2008-02-13

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Free Jack on Sat Dec 13, 2008 9:39 am

Yeah but i want to give my sergeants each a spreadsheet with just their squad from the main reserve roster, because the sergeants are not allowed to the see the overall roster.
Free Jack
Free Jack

Number of posts : 1225
Age : 26
eLocation : eNottingham
E-rep function: : UYA owner, PCP member, Congressman (2nd Term), MoD apprentice
Registration date : 2008-04-06

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Deilos on Sat Dec 13, 2008 9:41 am

Ahh, I see.

Didn't know that it was possible.
Deilos
Deilos

Number of posts : 2613
Age : 26
eLocation : North West
E-rep function: : Lord, Battle Monkey
Registration date : 2008-02-13

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by rastari on Sat Dec 13, 2008 9:57 am

you can give people access so you could set them access to only the preadsheets that need to see im not too sure if you can do it for the same document
rastari
rastari

Number of posts : 2428
Age : 28
eLocation : india
Erepublik Username : rastari
E-rep function: : member of pcp
Registration date : 2008-11-22

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Free Jack on Sat Dec 13, 2008 9:59 am

Thats the problem i cant give them access to the overall spreadsheet, but if i create some new spreadsheets i will have to keep manually updating them which will take ages.
Free Jack
Free Jack

Number of posts : 1225
Age : 26
eLocation : eNottingham
E-rep function: : UYA owner, PCP member, Congressman (2nd Term), MoD apprentice
Registration date : 2008-04-06

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by rastari on Sat Dec 13, 2008 10:06 am

yeah that is a bit of a problem really, not too sure how to solve that, have you tried turning it on and of again?
rastari
rastari

Number of posts : 2428
Age : 28
eLocation : india
Erepublik Username : rastari
E-rep function: : member of pcp
Registration date : 2008-11-22

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by funky44 on Sun Dec 14, 2008 5:53 am

Phone rings.
Man: IT have you tried turning it off and on again?
Woman: yes.
Man: Is it plugged in.
Woman: Click, hangs up phone.
funky44
funky44

Number of posts : 1760
Age : 32
Erepublik Username : Funky44
Registration date : 2008-06-13

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Free Jack on Sun Dec 14, 2008 5:58 am

lol, anyone else watch IT crowd?!?
Free Jack
Free Jack

Number of posts : 1225
Age : 26
eLocation : eNottingham
E-rep function: : UYA owner, PCP member, Congressman (2nd Term), MoD apprentice
Registration date : 2008-04-06

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Javache on Sun Dec 14, 2008 5:59 am

Free Jack wrote:lol, anyone else watch IT crowd?!?
Yeah, awesome show
Javache
Javache

Number of posts : 45
Age : 29
Erepublik Username : Javache
E-rep function: : RN Platoon B Corporal
Registration date : 2008-12-13

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Taytaz on Sun Dec 14, 2008 6:02 am

What series are you on in the UK?
Taytaz
Taytaz

Number of posts : 3846
Age : 110
eLocation : New South Wales, Australia
Erepublik Username : Taytaz
E-rep function: : Australian Minister of Foreign Affairs, PCP Congressman, Commander of Australian Defence Force
Registration date : 2008-10-01

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Free Jack on Sun Dec 14, 2008 6:03 am

half-way through series 3
Free Jack
Free Jack

Number of posts : 1225
Age : 26
eLocation : eNottingham
E-rep function: : UYA owner, PCP member, Congressman (2nd Term), MoD apprentice
Registration date : 2008-04-06

View user profile

Back to top Go down

Spreadsheet Help? Empty Re: Spreadsheet Help?

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum