Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data entry for two worksheets
I am using two worksheets in the same workbook for date, address, file #,
etc. One has 10 columns, the other has three with the same data. I am trying to avoid retyping the same info in the second worksheet. I know you can paste special from cell to cell, but is there a way to enter the same data in the identical columns? This is probably simple, and I'm sorry to be so lengthy. Thanks - MD |
#2
|
|||
|
|||
It is simple! Just have the 3 columns on page 2 read the values on page 1
with an = sign. For example if you put this formula in sheet2: =sheet1!B2 it will always read the value in B2 of sheet1. So anytime you make changes to sheet1, sheet2 will be updated. hope this helps! "Mark from Michigan" wrote: I am using two worksheets in the same workbook for date, address, file #, etc. One has 10 columns, the other has three with the same data. I am trying to avoid retyping the same info in the second worksheet. I know you can paste special from cell to cell, but is there a way to enter the same data in the identical columns? This is probably simple, and I'm sorry to be so lengthy. Thanks - MD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Copying data within worksheets with lookups | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions |