Append data from newly created worksheets to another sheet in thesame workbook

T

Tonso

Using XL2003, I use a macro create a form that is a copy of a
worksheet in the same workbook. After I fill in this, I would like to
append parts of the form [cells D5, Q1, T1, and S5] to another sheet
in the same workbook that I use as a database.[S5 is a formula, the
other cells are text] Cell D5 would go in col B, Q1 in col C, T1 in
col D, and S5 in col E. The 1st row of the database would be row 8.
Then, I use the macro mentioned above to create a new sheet [form],
and would want to append the same cells [D5,Q!, T1, S5] to the same
database, on row 9. As new sheets [forms] are created, I would of
course want to append those to database [rows 10, 11, 12, ....]. I am
at a loss how to accomplish this. It would be nice if, when I use my
existing macro to create a new form, links could be created to the
database worksheet in order to append the data, so if I later made a
change on a form, the database would be updated to show the new data.

Thanks,

Tonso
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top