Why separate worksheets when using excel?

Let’s learn why separate worksheets when using excel. The most accurate or helpful solution is served by Blurtit.com.

There are ten answers to this question.

Other solutions

Answer:

to perform different tasks

Read more

community wiki at wiki.answers.com Mark as irrelevant Undo

Answer:

Assuming that you're not misusing "worksheet" to mean "workbook" ... Many times...

Read more

TnAngel24 at Answerbag.com Mark as irrelevant Undo

Answer:

Using separate Excel worksheets can ... - help keep unrelated (or only slightly related) data separated...

Read more

Oddman at Blurtit.com Mark as irrelevant Undo

Using macro, how do i refresh all worksheets in excel file?

I have an excel file which is linked to another excel file stored on the network. using macro, i need to update/refresh this file at set intervals as the data in the source file is updated frequently. I am a beginner at this so please help

Answer:

First of all, you did not specify which version of MS-Excel you are using. So I will assume it to be...

Read more

Shardul P at Yahoo! Answers Mark as irrelevant Undo

Answer:

Use Save As instead of Save to save a spreadsheet as an HTML table. While the user will be able to view...

Read more

community wiki at wiki.answers.com Mark as irrelevant Undo

Excel

Hi Having a bit of a problem with printing with Excel. I have itemised the area on the worksheet I want to print and it is a single page. When I print the page and also when Preview the page it only prints or displays the top 2/3 of the required info...

Answer:

Eric, Highlighting an area is the first step. You must then select that area as the print area. Inversions...

Read more

Miningco.com Mark as irrelevant Undo

Vba printing in Excel 2003

QUESTION: I have this page in my workbook, there is a column of names. On the same page is a form. One name at a time needs to be copied to a field in the form so that the form can print and the next name copied and the form prints. By using the macro...

Answer:

using a number in the current context would not work unless you wanted to add a loop counter For i...

Read more

Miningco.com Mark as irrelevant Undo

Excel compress attachment

QUESTION: I just want to let you know I did not know anything about macros until half an hour ago when I was researching a way to unhide all sheets from a workbook. After finding a way to save this function for future reference, I started wondering if...

Answer:

Samantha, for the record, this question was answered in 1 hour and 45 minutes even though it was sent...

Read more

Miningco.com Mark as irrelevant Undo

Can this excel sorting macro be made to work on any selected range?

Inside is a recorded excel macro, designed to sort a specific range of cells on a specific worksheet from smallest to largest, from left to right, using the values in a specific range of cells in a row. Is there a way to edit this macro so that it will...

Answer:

You can replace this: ActiveWorkbook.Worksheets("15") with just ActiveSheet to get the sheet...

Read more

Lentrohamsanin at Ask.Metafilter.Com Mark as irrelevant Undo

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.