Question about Computers & Internet

2 Answers

SPREADSHEETS I've set up a spreadsheet that will allow me to track numerous items daily and give me the totals at the end of the week. Is it possible to set my sheet up to reset itself up to 5 times for the month so I can get a monthly total for reports, without have to set up 5 different weekly pages, to get totals for one month, then have to set up 12 pages to report for the year. I guess that i'm looking for a way to make the first week page reset itself but move to the 2 week and so on, with that process i'll be able to repeat for the months. Hope someone can help!!

Posted by on

Ad

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 205 Answers

I believe you could accomplish this with VBA (Visual Basic for Applications). There's lots of help and examples on using VBA available on the web.

Posted on Dec 08, 2007

Ad
  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 326 Answers

Excel is not able to be programed like that and still retain the data. Create 12 monthly spreadsheets and use them as they are needed.

Posted on Dec 08, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Crossposted:


For me some of applications what You have installed, corrupt windows system libraries, that is why windows is hanging/crashing while trying to open such us applications, If You have an original Install Disk, try with them, and if You still need them programs installed do it one by one doing clean restart of pc before You will install another one then You will find out witch one is causing problems for You.
Hope You will solve it.

Jun 03, 2013 | Sony VAIO Computers & Internet

1 Answer

Where can I download Microsoft Office 2007 for free?


Legally? You can't. Microsoft just does not give their stuff away.

If you want a free alternative - try OpenOffice - it is free and will handle all microsoft documents and spreadsheets, etc. You can even configure it to save items in a microsoft format by default.

Jan 10, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

I've forgotten how to transfer spreadsheets from my computer to my flash drive (been a long time since I used it!) Probably need a new one for more space - how can I tell?


right click on the drive select properties will tell you how much free space is on your drive
click start all programs open windows explorer navigate to the spreadsheets the select the spreadsheets right click copy and then paste them into your cruzer usb or select all spreadsheets click and hold the cursor and drag and drop them into cruzer or right click and select send to cruzer
hope this helps

Dec 31, 2010 | SanDisk 2GB Cruzer Micro SDCZ62048A10 Hard...

2 Answers

How is sharing information associated with computer networks?


In a Computer network, you can share Printers, Files such as documents, pictures and with certain software, you can share email accounts, Spreadsheets and much more.

I’m happy to assist further over the phone at https://www.6ya.com/expert/joe_8b8c2cd6ce148309

Nov 15, 2010 | Computers & Internet

2 Answers

Printer will only print purple spreadsheets


you set the printer properties to print in gray scale

Aug 01, 2009 | Office Equipment & Supplies

1 Answer

Excel spreadsheet is protected. I do not remember the password. how can i get in?


lok on google for password cracker for excel download and it will open any locked spreadsheet

Oct 14, 2008 | Microsoft Office Standard for PC

1 Answer

Spreadsheets


You need to calculate the totals for each category, by entering a formula such as: = C2 * 12.00 where C2 is the location of the hours and your hourly rate is $12.00. You can fill in the C2 part in each formula by clicking on the cell you want the total in, then typing the equal sign, then selecting the cell that you want to get the hours from, then enter the multiply operator (asterisk *) which is a Shift + 8 on your keyboard or the * over the 9 key on the numerical keypad. Repeat for each entry, using the correct cell and the correct amount (in this example it might be $18.00 for overtime hours). Then you just total all the formulas by using Autosum, which you invoke by using the Ʃ symbol, which will give you a sum of the cells you select. If this isn't clear enough, please let us know.

Hope this will FixYa!!!

Mar 03, 2008 | Computers & Internet

1 Answer

Consolidate few sheets under 1 excel


What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.

Dec 18, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

80 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...