J
jimkurdek
Is there a way to enter new data into multiple excel worksheets in Office
2003 if the cells do not match. I understand the idea of grouping if I am
trying to enter something into the same cell on multiple sheets but is there
a way to enter the same data into multiple sheets if I do not want it to go
to the same location every time?
For example, on Sheet 1 I have a list of companies in Column A and the next
several columns list various data points for each company listed in column A.
For reference sake, lets say that the company I am dealing with is Coca-Cola,
which is located in cell A22. I would like to enter a new data point into the
Coca-Cola row, for example, "Listed on the NYSE" into cell F22, because
columns B through E are already populated. Now, on another worksheet in the
same workbook I have Coca-Cola in cell A45 and I also want to add the data
"Listed on the NYSE" to the end of its data points, in this case in cell F45.
Is there anyway to program the spreadsheet to recognize that I have entered
data into the Coca-Cola row and to enter the same data into every Coca-Cola
row in the workbook?
Sorry if this is confusing, I appreciate the help! I will be happy to
clarify further if needed.
2003 if the cells do not match. I understand the idea of grouping if I am
trying to enter something into the same cell on multiple sheets but is there
a way to enter the same data into multiple sheets if I do not want it to go
to the same location every time?
For example, on Sheet 1 I have a list of companies in Column A and the next
several columns list various data points for each company listed in column A.
For reference sake, lets say that the company I am dealing with is Coca-Cola,
which is located in cell A22. I would like to enter a new data point into the
Coca-Cola row, for example, "Listed on the NYSE" into cell F22, because
columns B through E are already populated. Now, on another worksheet in the
same workbook I have Coca-Cola in cell A45 and I also want to add the data
"Listed on the NYSE" to the end of its data points, in this case in cell F45.
Is there anyway to program the spreadsheet to recognize that I have entered
data into the Coca-Cola row and to enter the same data into every Coca-Cola
row in the workbook?
Sorry if this is confusing, I appreciate the help! I will be happy to
clarify further if needed.