How to transfer cell data as a result of input?

sureshn · May 10th, 2002, 12:09 AM

The task:

When user inputs, say, number '1' into cell D3 of Book1, sheet1, copy data in cell B3 of sheet1 to cell B3 of Book2, sheet1.

Similarly, if the number '2' is the input, copy data in cell B3 of sheet1 to B3 of Book2, sheet2.

Thanks.

Anne Troy · May 10th, 2002, 12:43 AM

Put something like this into your sheet 2 cells:

=sheet1!b2

May 10th, 2002, 12:43 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Put something like this into your sheet 2 cells: =sheet1!b2 __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 12:09 AM	#1
sureshn New Member Join Date: May 2002 Location: Kuala Lumpur Posts: 1	The task: When user inputs, say, number '1' into cell D3 of Book1, sheet1, copy data in cell B3 of sheet1 to cell B3 of Book2, sheet1. Similarly, if the number '2' is the input, copy data in cell B3 of sheet1 to B3 of Book2, sheet2. Thanks.