Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-30-2014, 01:47 PM
stuwoolf stuwoolf is offline Using IF statements Windows 8 Using IF statements Office 2010 64bit
Novice
Using IF statements
 
Join Date: Dec 2014
Posts: 14
stuwoolf is on a distinguished road
Default Using IF statements

I have constructed a spreadsheet with 4 tabs. Tab 1 is the source document and the cells in Tabs 2-4 are linked to cells in Tab 1. Each tab has 4 banks of weeks as shown in the diagram below.

Due to the different permutations of data that can be input, in order to populate the cells in Tabs 2-4 I have used the IF function. Certain parts of Tab 1 are protected to restrict input and all areas of Tabs 2-4 are protected.

In the diagram below I have added column and row identifiers for ease of reference.





In Tab 1, Column A and Column C are hidden. These columns are used to sort the data by either alpha on surname or Band. Tabs 2-4 also have this information and that too is hidden. The data is not sorted using Tabs 2-4.


I had hoped that, when sorting the data in Tab 1 that all the linked data in Tabs 2-4 would sort in the same way. That is not happening and I assume its due to using the IF function.

Is this a correct assumption?

The question I have then is how to sort Tab 1 by either Surname or Band and for the sort to be correctly reflected in Tabs 2-4?

Grateful for any assistance and indeed advice on how to make this task easier and/or more efficient.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using IF statements Multiple If statements, Jamal NUMAN Excel 16 11-15-2022 11:59 PM
getting IF and OR to work for 3 IF statements nero6014 Excel 3 09-16-2014 07:28 AM
Using IF statements count if statements Alaska1 Excel 1 05-14-2014 08:21 AM
If Statements in a form Sammie0Sue Word VBA 4 03-12-2014 01:16 AM
Multiple If statements bremen22 Excel 2 10-15-2013 06:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft