I HAVE AN EXCEL DOCUMENT WITH FOUR TABS, i WOULD FOR INFORMATION I TYPE ON TAB 1 TO AUTOMATACLY FILL IN ON TABS 2,3 AND 4. iS THIS POSSIBLE?? FOR EXAMPLE IF I TYPE A PERSONS NAME IT WILL GO TO ALL THE DOCUMENTS IN THE CORRECT PLACES.
2007-03-28 16:58:47 · 2 answers · asked by sandra m 1 in Computers & Internet ➔ Software
Type information in Tab1. Copy.
Go to Tabs 2,3,4 and Paste - you will a box to check "as link"
If you paste as link, whatever you typed in the original cell or any changes made will be reflected in the pasted cells.
2007-03-28 17:10:19 · answer #1 · answered by TheHumbleOne 7 · 0⤊ 0⤋
Select all sheets. (Right click on sheet name and click on "Select All sheets"). Now whatever you type in a particular cell (say C5), will automatically be populated in C5 in all sheets. (Note that this actually "group"s the sheets. You need to ungroup the sheets once done. Ref http://www.cof.orst.edu/net/software/excel/tips/ --> "Grouping sheets"
If you want to populate in different cells in different sheets, then you need to link them through formula before hand so that when you in a particular cell, the other cells take the same value.
2007-03-29 03:38:28 · answer #2 · answered by AP 2 · 0⤊ 0⤋