I am in a situation where we're using an Excel sheet to massively inpu
a lot of data into a database. The Excel sheet with its data is bein
imported into the database. Anyway, the problem focuses on th
efficiency of the Excel sheet...

To illustrate a clear example:
COLUMN_A : Artists
COLUMN_B : Albums
COLUMN_C : Songs

For certain reasons it's necessary to have the input like that: for a
artist albums are enlisted and for each album the songs. It means tha
with the entry of each new song for an already specified Artist an
Album I have to repeat the artist and the album.

This can be done by means of dragging the value with the mouse an
filling all fields in the column that are the same. But it has to b
more efficient.... automatically. That's a big demand right now fro
some datatypist who want to focus on entering as much as possible i
little time. For us, we don't work with Artists, Albums and Songs..
but it gives you an idea of what it's about :)

What I'd like is to specify an Artist with an Album and start with th
first song. I press [enter] and the focus is on the Song field in th
next row. I'd like to create a Macro and event catcher so that wit
each [enter] (entering the next row) the values of the fields fo
COLUMN_A and COLUMN_B are copied from the previous row. If it's a ne
album or artist at some point... a user can change it and from tha
point on that album or/and artist will be used as previous value.

Problem. I'm not at all experienced in Excel programming. I guess tha
this may be quite a simple trick or macro to get it to work, but for m
it's a big problem. Tried some things, but ended up with nothing tha
worked even remotely.

I couldn't find some good tutorial on getting this issue solved. It'
not my wish to learn Excel extensively. It just happens that out of th
blue we end up with one very wished for feature of the Excel shee
(template) which is used a lot.

Anybody got some tips on the Macro itself... and secondly how to get i
to execute automatically on entering a new COLUMN_C field in the nex
row (trigger)?

Thanks BIG time if someone can help :

--
Lav
-----------------------------------------------------------------------
Lava's Profile: http://www.excelforum.com/member.php...fo&userid=2779
View this thread: http://www.excelforum.com/showthread.php?threadid=47311