View Single Post
 
Old 09-29-2010, 06:56 AM
diegogeid diegogeid is offline Windows 7 Office 2010 (Version 14.0)
Novice
 
Join Date: Sep 2010
Posts: 4
diegogeid is on a distinguished road
Default How to syncronize data in two different sheets

I have a sheet with two columns and some data, and another sheet with a column and the same data of the first column in the first sheet, but in a different position. So, i need to insert in the column 2 of the second sheet the correct data.
How can i do it?

Example:

_Sheet 1:

Column1 Column2
A 1
B 2
C 3

_Sheet 2:

Column1 Column2
if B --> 2
if C --> 3
if A --> 1


Thanks
Diego
Reply With Quote