The spreadsheet two worksheets, the first worksheet has a list of 50-60
schools downwards alphabetically in column A. Columns B - K have different
headings ie how many classrooms etc. In the second worksheet the same
headings are there but the list of schools in column A are not in
alphabetical order. I would like to enter the information beside one school
under a specific column and have it populates the same school and heading in
the other worksheet. Have I explained enough, can you help? Thanks.

"Joel" wrote:

You ared not giving me a clue at the destination location. How do yo know
where the data needs to be writen.

"slavenp" wrote:

Thanks for the reply. I'm new to the world of excel and unsure if this would
help. The spreadsheet I have lists details down 50-60 rows and has 12 colums
and then the details are in a differnt order on another. Does that explain
enough?


"Joel" wrote:

Sometimes you can use a worksheet_change VBA macro. Your request is too
general to see if it is applicable.

"slavenp" wrote:

I would like to know how I can type text in one cell and it copies the same
text in another cell but on a different row and sheet. A quick cut and paste
is not the answer as I have numerous inserts.