User input

[Mark Flaxman]

I've used this forum before, and found it very useful.

I need to set up a worksheet, (worksheet1), to allow a
user to input surname,initials,id,location,date for
office files that move around the office. The result will
be stored in worksheet2 in 1 row and 5 columns called
Surname - Inits - ID - Location - Date

Each entry will be recorded in the next empty row in
worksheet2. I think I have found a way to identify the
next empty row using the Indirect function.

But, how can I set up worksheet1 to allow the user to
input the data he has which is then automatically
recorded into worksheet2?

This is more a database type workbook, but regrettably
our firm does not supply Microsoft Access.

Many thanks for any advice anyone can give.

 

[Dave Peterson]

You may be able to do this with a macro, but lots could go wrong. The user may
disable macros when opening the file or just turn off events.

I think I'd take a different approach.

Do your best to keep all the data in one worksheet. But with a judicious use of
Data|filter|autofilter, hidden columns, custom views, data|group, you might be
able to show just what you want (for different "reports").

If that doesn't sound like it would work, then I'd still try to keep the data on
one worksheet and use an on-demand macro to copy to a new worksheet (and if I
needed to update that second sheet, I'd delete it and recreate it).

 

[Mark Flaxman]

Dave,

Many thanks for your advice. I figured there would be no
easy solution.

I was reluctant to use macro's myself. Like you said,
it's an option that could go wrong, and the LAN Admin
would probably veto macros anyway because of the risk of
trojans/viruses etc.

I haven't used filter/auto filter before, so I guess I'd
better start learning,

Thanks again m8