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
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
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.
×
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.
424 views
Usually answered in minutes!
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
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
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
×