Taking information from one page and having it automatically

FlashG · Jan 14th, 2002, 01:50 PM

I want to take information from one sheet and have it print directly to other sheets so I don't have to copy and paste. Example:
Information Sheet
Name: John Smith
Address: 1234 Main Street

Sheet #1
John Smith in the name cell
1234 Main Street in the address cell
and so on.

Please understand, I am not real sharp at this but I would love to learn how to accomplish this. I write sales contracts and having to repeat, over and over the name and address and so on is time consuming.

Please help if possible.
Thanks,
Gordon

Phylis Sophical · Apr 14th, 2002, 10:29 PM

If the information goes into the same cell on every sheet, select all the sheets at once. When you type the info in the first sheet, it will be copied in all of them.

To select all sheets, click the first one, hold down the Shift key and click the last one.

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

Jan 14th, 2002, 01:50 PM	#1
FlashG New Member Join Date: Jan 2002 Posts: 1	I want to take information from one sheet and have it print directly to other sheets so I don't have to copy and paste. Example: Information Sheet Name: John Smith Address: 1234 Main Street Sheet #1 John Smith in the name cell 1234 Main Street in the address cell and so on. Please understand, I am not real sharp at this but I would love to learn how to accomplish this. I write sales contracts and having to repeat, over and over the name and address and so on is time consuming. Please help if possible. Thanks, Gordon

Apr 14th, 2002, 10:29 PM	#2
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	If the information goes into the same cell on every sheet, select all the sheets at once. When you type the info in the first sheet, it will be copied in all of them. To select all sheets, click the first one, hold down the Shift key and click the last one.