LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
RidingClubSec
 
Posts: n/a
Default Import from One Sheet to various Sheets Automatically


Background: We have a Workbook with 58 Sheets for our Riding Club Shows (one
for each class) When a Competitor enters the horse show they select which
classes they wish to compete in. Currently we type in their details in three
columns on the sheet for the first class they enter, copy the three cells and
paste them into the next available line on the rest of the sheets/classes
they have entered. When the Competition is ready to start for each class we
print the sheet for the Judge to use.

What we want Excel to do: .. it would be easier if we could input the three
cells of data onto a single sheet and then in the next Cell enter the
sheets/classes they have entered (eg: 5, 9, 27, 51, 58) and then have Excell
automatically input the three detail cells into the sheets on their next
available line.

It is probably really easy answer but I have no knowledge of working with
Excel, and we are a Non-Profit Sports organisation mainly for young riders to
compete with us..


--
Total Amateur at Excel - Please help
 
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
Selecting Last Sheet Bonbon Excel Worksheet Functions 17 February 22nd 06 04:16 PM
Combining data from cells from several excel sheets to a new sheet Rik Excel Discussion (Misc queries) 4 February 22nd 06 09:16 AM
Linked sheets with sequencial order in 2ΒΊ Sheet Micos3 Excel Discussion (Misc queries) 0 February 14th 06 05:34 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


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