Sending data to cell
Hi,
If I have data in Sheet1, cell A3 and I want it to appear in Sheet2 cell D6, I can put a formula in Sheet2,D6 - something like =Sheet1!A3. How can I send the data to Sheet2,D6 without having a formula in D6? Thanks in advance. Regards, Ken Rock |
Without a macro, you can't. Why can't Sheet2!D6 accommodate a formula?
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ken Rock wrote: Hi, If I have data in Sheet1, cell A3 and I want it to appear in Sheet2 cell D6, I can put a formula in Sheet2,D6 - something like =Sheet1!A3. How can I send the data to Sheet2,D6 without having a formula in D6? Thanks in advance. Regards, Ken Rock |
Jon Peltier wrote:
Without a macro, you can't. Why can't Sheet2!D6 accommodate a formula? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Ken Rock wrote: Hi, If I have data in Sheet1, cell A3 and I want it to appear in Sheet2 cell D6, I can put a formula in Sheet2,D6 - something like =Sheet1!A3. How can I send the data to Sheet2,D6 without having a formula in D6? Thanks in advance. Regards, Ken Rock Many thanks for your prompt response. I want to insert some data into a cell in Sheet 1 which will cause a ripple-through effect resulting in more pieces of data appearing in cells elsewhere in Sheet 2. These resultant additional pieces of data are then detected and automatically re-inserted into Sheet 1, whereupon, more data appears in Sheet 2...etc. At this stage, I do not know where the generated data will turn up and therefore I cannot put a formula into the required cell. Having detected and located the new data in Sheet 2, I have to send it to Sheet 1. I am also worried about creating circular references. I hope I have defined my problem clearly enough. Regards, Ken Rock |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com