| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying cell info from one sheet to another in the same wkbk
I have 5 forms (all formatted differently) that need to be filled out for
each transaction. They all contain the same information. I would like to fill out the first sheet and it automatically fill in the subsequent sheets. Tired of forms! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying cell info from one sheet to another in the same wkbk
Use formulas in the subsequent sheets refering to the 1st sheet.
For example to get Sheet A1 value in Sheet A2 enter the formula in Sheet2 A2 =Sheet1!A1 If this post helps click Yes --------------- Jacob Skaria "shellyjohnson" wrote: I have 5 forms (all formatted differently) that need to be filled out for each transaction. They all contain the same information. I would like to fill out the first sheet and it automatically fill in the subsequent sheets. Tired of forms! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| info mtg criteria from one wkbk to another | Excel Discussion (Misc queries) | |||
| Formula for copying tap info into a cell | Excel Worksheet Functions | |||
| Large wkbk won't recalc after moving sheet | Excel Discussion (Misc queries) | |||
| How do I replicate an area of a SS onto another sheet in same wkbk | Excel Discussion (Misc queries) | |||
| Opening Multiple files and Copying the info all to one other sheet | Excel Discussion (Misc queries) | |||
Linear Mode
