I am creating a proposal tool for our company and am hitting a bit of a
roadblock. There are three sheets, a worksheet for the employee to
input information , then a cover sheet and the actual proposal meat. My
issue is on the third sheet where the proposal is, I need the
information the employee inputs into sheet one to automatically flow to
sheet three. I can get it do that no problem by having the cells
reference sheet one. What I don't want is to have to predetermine all
the cells. I want it to do it for me. So the Total line and signature
of acceptance will automatically move down the page on sheet three as
new items are input into sheet one. Is this possible. I would
appreciate any help you guys have. Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

How about using a List control?

"Dell" wrote in message
...



I am creating a proposal tool for our company and am hitting a bit of a
roadblock. There are three sheets, a worksheet for the employee to
input information , then a cover sheet and the actual proposal meat. My
issue is on the third sheet where the proposal is, I need the
information the employee inputs into sheet one to automatically flow to
sheet three. I can get it do that no problem by having the cells
reference sheet one. What I don't want is to have to predetermine all
the cells. I want it to do it for me. So the Total line and signature
of acceptance will automatically move down the page on sheet three as
new items are input into sheet one. Is this possible. I would
appreciate any help you guys have. Thanks.

*** Sent via Developersdex http://www.developersdex.com ***