Automatically updating cells on other worksheets when data typed into primary sheet

  • Thread starter Thread starter N Davies
  • Start date Start date
N

N Davies

I'm trying to create a workbook that will allow me to enter data on the
first sheet and it will then append the data to a second sheet by
automatically starting a new line.


Example:
I enter "This is a test" into A1 on sheet 1
First available line on sheet2 automatically updates with "This is a test"

When it comes to enter something new in A1 on sheet1, same function above
goes into action, accept it should be on the next available line which will
be A2 on sheet2, as A1 is already used by previous data entry.

Can this be done?

I would appreciate any help with this.

NDavies
 
Hi
this would require VBA and using an event procedure. Is this a feasible
way for you?
 
You have asked more or less the same question in microsoft.public.excel and
received two replies. If the answers don't help, post back in the same thread
and you will get quicker and better answers, rather than starting a new thread
in another group.

Regards
Anders Silven
 
Thanks for the reply Frank. I think youv'e responded to a similar question
posted by me on exceltips forum!

It sounds like it's what I need. I'm fairly new to working with Excel at
this depth, but capable of picking up anything new quite quickly.

Can you suggest anywhere that has free sample downloads that I can view and
give me ideas on where I need to start?

Regards

Nigel
 
Back
Top