How to make Excel create and fill another document when filling a

H

HumbleStudent

Is it possible for Excel to create and fill another spreadsheet when I start
filling the row of an existing one? If so, can someone point me in the right
direction?
 
K

kassie

Depends what you mean with "fill another spreadsheet when I start filling"
Once you have filled, it is easy, fill simultaneously, I don't think so. To
create the other sheet, you would use a macro, and to copy your info across,
you would still use a macro. If you do not know about macro's, you have some
studying to do, but not that difficult once you grasp it.
 
H

HumbleStudent

Thank you. The row 1 columns consist of questions. From row 2 on down, each
column contains the answer to the corresponding question of that column. Each
row contains the information particular to a device. I want to make every row
produce and save that information in a file that belongs to that device. I
hope I make some sense.
I will however, read up on macros. If I am still not able to do what I am
attempting, then I will post another question.

HumbleStudent
 
G

GurlRossGurl

If I'm making sense of what you're saying, all you need do is "link" your
worksheet to another. As you enter data in one worksheet, it also entered in
the other. Links are very powerful and are easy. Copy your primary
worksheet to have the same formatting Worksheet(2). Then click in the
corresponding cells of worksheet(2) to match those of worksheet(1). You can
link your questions to any cell or worksheet you'd like...and be creative
with conditional formulas that will link just the information you want.
 
Top