Question

Locked

Anyone good with manipulating an Excel spreadsheet

By mr_t_wright ·
For some reason the food service lady thinks that I would know how to do this being that I manage the "Network" Can anyone help with this? She has a Excel program that she wants to do some calculations and output to a report..


are: In column A -we can insert a dollar amount that would subtract each time a "1" is entered in column I through AO. The amount in column A would then decrease by a certain amount determined by the code represented in column F and those amounts would differ between breakfast and lunch.

Also, I'd like for certain cells to be protected and the last page is the page that adds all the information together and calculates the campus of residence report. If we can get more info on that page and have it calculate and be protected. Then Columns I through AO in this section would then be transported to the Accuclaim Report that is also attached.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

i think

by SystemCheck In reply to Anyone good with manipula ...

you can do that under tools and then protect

Collapse -

more info

by mr_t_wright In reply to i think

sorry I have not idea what you mean, tools and protect and, then I can do all that I need?

Collapse -

Why not just tell the lady....

by ThumbsUp2 In reply to more info

... that you don't have a clue how to open Excel, let alone create the formulas necessary for the calculations and everything else she's asking for.

After all, if you're not up to the task, just TELL HER.

Collapse -

I know a bit, just very rusty...

by mr_t_wright In reply to Why not just tell the lad ...

Well that is not so. Its been a while since I have worked in Excel. Not since high school, but I do remember being able to create formulas where you can take the contents of this cell add it with the contents of that cell and put it in the other cell. Or am I misremembering? Is there not such formulas?

Collapse -

excel..

by SUNI_U786 In reply to Anyone good with manipula ...

for the protection u can use "tools-allow user to edit renges"option.
2 transfer data from 1 page to other simply method from the destin page-select cell-
=Sheet1!A1(example).
first qust.u said once subtract then again decrease.subtract frm what?

Collapse -

Thanks.

by mr_t_wright In reply to excel..

Thanks that was helpful...

In column A -we can insert a dollar amount that would subtract each time a "1" is entered in column I through AO. The amount in column A would then decrease by a certain amount determined by the code.. Its a food service spreed sheet that calculates how many students had pre-paid lunch, paid and so on. So in column A lets say a student had $500, every time a "1" was inserted in columns I through AO the 500 should decrease.

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums