sumesh56

Senior Member

Posts: 118

is it possible to ask excel to input from another sheet?

A worksheet realted to the conduct of exams.
I have a sheet named SEATING PLAN which says who to sit in which exam room.
I have another sheet named DISTRIBUTION which displays each class division to diffeent exam roooms.
What i am doing is first prepare the seating plan then copy paste the concerned lines(col C:E) to the distribution sheet. This is a tedious job.
Is it possible to ask excel to do the job for me? I will prepare the seating plan and excel has to fill the distribution sheet columns C:E. thanks.pls see the sample excel file attached.

Attached Files

test seating plan 210314.zip (13.7 KB, 90 views)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Input the filename into Excel Sheet	Li Jianyong	Excel Programming	4	July 26th 08 04:39 PM
Protecting excel sheet for data input	rdrnws	Excel Discussion (Misc queries)	1	November 23rd 06 10:38 AM
Protecting excel sheet for data input	rdrnws	Excel Programming	1	November 23rd 06 10:38 AM
How do I input info from sheet to a graph in Excel?	Charts	Charts and Charting in Excel	1	December 19th 05 08:25 PM
input mask in excel sheet	Osama Mira	Excel Worksheet Functions	1	December 4th 05 05:59 PM

All times are GMT +1. The time now is 06:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us