Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
I have two columns of data that should be identical. I want the second colun
of data to change when I change the first colun so they both have the same numbers. Is this possible. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
hi
you could use a fomula in second column. (where are the columns?) if sheet1 column A and B, then in column B put.... =A1 as A1 changes so does B1. if on a different sheet, both column A then in column A sheet 2 put.... =Sheet1!A1 as sheet1 A1 changes so does sheet2 A1 draw back. it does work both ways. only changes in sheet1 A1. Regards FSt1 "deb" wrote: I have two columns of data that should be identical. I want the second colun of data to change when I change the first colun so they both have the same numbers. Is this possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) |