Cells Fill Automatically on Another Workbook

B

BrazosJoe

I've created what we'll call a seed worksheet to be used over and over for
different clients. I have linked its cells to another workbook. As the
originating seed worksheet directs its cell data to a specific cell on
another workbook, how can I accomplish the workbook data not being
overwritten but the new incoming data default to the next unused cell in the
column? i.e. If the original seed worksheet cell B1 links to the worksheet
cell A1, I would like the next instance of creating a new customer and his B1
information on his use of the seed worksheet to populate onto the workbook's
sheet in cell position A2. And so forth. Help!
 

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