Lava,
Maybe...
Enter only the song title and add the artist and album each time
they change. Then use John Walkenbach's tip here...
http://www.j-walk.com/ss/excel/usertips/tip040.htm
to fill in the blank cells after the data entry is complete.

Jim Cone
San Francisco, USA


"Lava"

wrote in message
...

I am in a situation where we're using an Excel sheet to massively input
a lot of data into a database. The Excel sheet with its data is being
imported into the database. Anyway, the problem focuses on the
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 an
artist albums are enlisted and for each album the songs. It means that
with the entry of each new song for an already specified Artist and
Album I have to repeat the artist and the album.

This can be done by means of dragging the value with the mouse and
filling all fields in the column that are the same. But it has to be
more efficient.... automatically. That's a big demand right now from
some datatypist who want to focus on entering as much as possible in
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 the
first song. I press [enter] and the focus is on the Song field in the
next row. I'd like to create a Macro and event catcher so that with
each [enter] (entering the next row) the values of the fields for
COLUMN_A and COLUMN_B are copied from the previous row. If it's a new
album or artist at some point... a user can change it and from that
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 that
this may be quite a simple trick or macro to get it to work, but for me
it's a big problem. Tried some things, but ended up with nothing that
worked even remotely.

I couldn't find some good tutorial on getting this issue solved. It's
not my wish to learn Excel extensively. It just happens that out of the
blue we end up with one very wished for feature of the Excel sheet
(template) which is used a lot.
Anybody got some tips on the Macro itself... and secondly how to get it
to execute automatically on entering a new COLUMN_C field in the next
row (trigger)?
Thanks BIG time if someone can help :)--
Lava