From: BrazosJoe on
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!
Thanks! BrazosJoe