LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Assign value to a variable name


Hello. I am creating an Excel workbook for scheduling and billing
tutored students. One sheet contains the schedule, another the students
and their rate, and the last the teachers and their rate. The rates
won't be visible in the schedule sheet, only the student and teacher
names. Therefore, I need to assign the value of the rate to the name as
though the name were a variable. If the values were updated they would
need to update on the schedule sheet too, where the final calculating
happens. This is complicated by the fact that students and teachers can
be moved to any time slot.

I looked at "Linked Objects" but saw nothing about assigning values to
a variable name. If it is possible, how would I do it?

Thanks!


--
Gnarlodious
------------------------------------------------------------------------
Gnarlodious's Profile: http://www.excelforum.com/member.php...o&userid=37779
View this thread: http://www.excelforum.com/showthread...hreadid=573502

 
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
Aling multiple sets of data by header column MarkusO Excel Discussion (Misc queries) 2 April 12th 06 07:29 PM
How do I assign a text value to a variable number of rows? Jday Excel Worksheet Functions 6 June 20th 05 01:46 PM
Variable VB to assign new sheet name Kevin M Excel Worksheet Functions 0 June 17th 05 12:15 AM
How can I assign a range starting cell based on a variable locati. feman007 Excel Discussion (Misc queries) 1 March 9th 05 11:41 PM
How can I assign a range starting cell based on a variable locati. feman007 Excel Worksheet Functions 3 March 9th 05 11:40 PM


All times are GMT +1. The time now is 08:18 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"