LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Changing 2 cells based on another cell

I have a spreadsheet that has teachers first names in column A and their last
names in column C. Their room number is in column F. I need to change the
teachers' first & last names based on the room number. The problem I am
encountering is there is about 75 teachers, much more than the IF function
will handle. For some reason when we pull our report out of the system to
Excel, the teachers names are not acurrate to the rest of the report.

Please help.

Jase4now
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Cell Background Color based on data from another cell Speedy Excel Discussion (Misc queries) 2 March 16th 09 04:10 PM
Changing cell text color based on cell number W. Wheeler Excel Programming 0 April 22nd 07 11:56 PM
Changing a cells type based on it's value Keith Excel Worksheet Functions 2 April 18th 07 01:34 PM
Changing cell text color based on cell number scotty Excel Programming 9 April 14th 07 06:34 AM
Changing the color of a cell and adjacent cells based on conditions Matt[_42_] Excel Programming 2 September 6th 06 01:34 PM


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"