Question about Microsoft Office Standard for PC

1 Answer

Excel Sort Across Sheets

I have a workbook with 3 sheets. Sheet 1 has the Names, Date of Birth and ADM No. of learners. Sheet 2 and 3 has formulae echo-ing the data in sheet 1 and columns with marks for each of 2 learning areas - one on each sheet. PROBLEM: I need to be able to sort across the sheets ie if the names get swopped in sheet 1 then the corresponding marks in sheet 2 and 3 must also be swopped. Thanks Raymond

Posted by Anonymous on

  • 1 more comment 
  • Anonymous Sep 18, 2007

    Hi DeltaC

    Thanks but the problem is the rest of the columns on sheet2 and Sheet3 that are not linked to sheet1. So if sheet1 has only the names and sheet2 has names and say marks then the marks will remain where they are and be in the line of the wrong names.

    Thanks
    Ray,ond

  • Anonymous Dec 01, 2008

    The rest of the columns in shetts 2 and 3 will stay where they are - so they will not match the correct names. So if JIM moves one row down he will appear 1 row down on all 3 sheets but the other fields that were in line of JIM on sheets 2 and 3 will remain where they are.

    Thanks

  • ceenub May 11, 2010

    Hi Sir.

    This is srinivas i want to learn excel sheet


    but i unable to understand what i read above.

    Please do the needful and solve the problem

×

Ad

1 Answer

Anonymous

  • Level 1:

    An expert who has achieved level 1.
    Corporal:

    An expert that has over 10 points.
    Mayor:

    An expert whose answer got voted for 2 times.
    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 12 Answers

Hi Raymond, I have a solution for you. Asuming your 'main' sheet is Sheet1. On Sheet2, in the same line as your data on sheet1 (i.e. A5 on sheet1 is JIM), then on A5 on sheet2, enter a link ( the = ) and enter. copy this formula down. Do the same with Sheet3 linking to Sheet1. When you sort Sheet1, Sheet 2 and 3 will follow. Hope this helps. Regards DeltaC

Posted on Sep 13, 2007

  • Raymond Elixer Sep 17, 2012

    hi carol when i said that the sheets 2 and 3 have formulae echoing data in sheet one - what you suggest is exactly what i have. If you sort sheet 1 then sheets 2 and 3 will also apparently get sorted because the formulae will echo the corresponding values. The problem is the new data on sheet 2/3 in the remaining columns will stay where the are. So the student whose name is in row i sheet 1 will have his marks on row 1 sheet 2. If the sort moves his name to row 2 - his name will be on row 2 on the other sheets but his marks will remail on row 1 on sheet 2 etc. Try it.

×

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

What is the easiest way to link several formulas from seperate worksheets?
pen both the sheets in the same window as:-
1. View Tab-->New Window --> Arrange All --> tiled
2. Open first sheet in first window and second in second window
3. now create formula simply by clicking in corresponding sheets and selecting cells.

Alternatively you can use following format of addressing:-
1. SheetName!CellAddress (Same Workbook)
2. [WorkbookName]SheetName!CellAddress (Different Workbooks)

For more clarification please mail on [email protected] with screenshots.

Jul 16, 2014 | Microsoft Excel for PC

2 Answers

What is exel sheet extension in office 2010 ?

Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

1 Answer

Setup multiple spreadsheet pages
Do you mean to display multiple sheets at the same time? Please check out the solution provided below (this applies to Excel 2003)

1.) To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.

2.) On the Window menu, click Arrange.

3.) Under Arrange, click the option you want.

To view sheets in only the active workbook, select the Windows of active workbook check box.

Apr 12, 2010 | Microsoft Excel for PC

1 Answer

Excel 2007: Conditional formatting
did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.

May 08, 2009 | Microsoft Excel for PC

1 Answer

Excel formula related to a date range
Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.
Then on Sheet 1, but the following formula in the cell you want an X to be placed in.
=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").
Make sure you type the formula Exactly as it appears.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

5 Answers

How to use vlookup in openoffice using different sheets
=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

1 Answer

Need to use the VLOOKUP formula for more then one column
You probably need to organise your pricelist sheet so that you only have 2 columns, product and price. If this doesn't fix you, please provide the syntax of your vlookup code.

Dec 10, 2008 | Microsoft Excel for PC

1 Answer

Matching data
1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

2 Answers

Unsure of correct formula
You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

1 Answer

EXCEL
I have solution for your second problem.
You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.

This will save some your valuable time.

Jan 09, 2008 | Computers & Internet

Not finding what you are looking for?

View Most Popular

Office Standard for PC

  • Computers & Internet

Related Question

What is the easiest way to link several formulas from seperate worksheets?

  • Microsoft Excel for PC

Open Questions:

0 Answers

NEED 25 CHARACTER VISIO 2013

Jun 06, 2014 | Microsoft Office Standard for PC

0 Answers

can you give me powerflashpoint product key ? i need it urgent

May 17, 2014 | Microsoft Office Standard for PC

0 Answers

microsof visio product key

May 12, 2014 | Microsoft Office Standard for PC

0 Answers

2013 office 25 character key

Jan 24, 2014 | Microsoft Office Standard for PC

See all Microsoft Office Standard for PC Questions

Related Topics

Microsoft Office Standard for PC Logo

420 views

Ask a Question

Usually answered in minutes!

Popular Questions

5 Answers
Get message that "Setup cannot find Office.en-us\OfficeMUI.msi"

Microsoft Office Professional...

3 Answers
Hi i need micro soft visio 2010 product key

Microsoft Office Standard for...

5 Answers
PROBLEM OF PRO11.MSI

Microsoft Office 2003 Pro...

3 Answers
HOW TO DOWNLOAD MS OFFICE 2007 FULL VERSION FREE

Microsoft Office Professional...

7 Answers
Confirmation code

Microsoft Office Professional...

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Lee Hodgson
Lee Hodgson

Level 3 Expert

4810 Answers

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

Muntejaya Ginting
Muntejaya Ginting

Level 3 Expert

10422 Answers

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

Answer questions

Manuals & User Guides

Loading...