Cells Fill Automatically on Another Workbook
in [Functions]
|
From: BrazosJoe on 15 Mar 2010 12:18 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
|
Pages: 1 Prev: Index/Lookup Function? Next: Dynamically Adding Textbox To Frame |