Thread: Move data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Horacio Horacio is offline
external usenet poster
 
Posts: 2
Default Move data

Hi!
I need some help please.
In a spreadsheet in column A i have numbers from 1 to 100 and in column
B I have data from some other spreadsheets.
Wat I wont to do is, if the data in column B change for another row then
the number in column A change to the same row of that data in column B.
Ex:
1 a
2 b
3 c
If the c move to the 1º place in column B I need the number 3 also in 1º
place
Thank you
Horacio