excel: external data "data range properties" button dosent work
 

hi,

i wrote a formula & copied it to the whole column. The original formula
received external information from column1 of a different excel spread
sheet.
I would like each consecutive copied fromula to take my formula & receive
the external info from the next consecutive column in the other spreadsheet &
etc. I know about the external data button, but my "data range properties"
button dosent work.
example of correct furmula for 3 consecutive rows:
[Book2]Sheet1!$G$2&" ct " &[Book2]Sheet1!$C$2& " Diamond, "&
[Book2]Sheet1!$E$2 & " Color, " &[Book2]Sheet1!$F$2 & " Clarity. " &
[Book2]Sheet1!$B$2 & " Certified. "
=[Book2]Sheet1!$G$3&" ct " &[Book2]Sheet1!$C$3& " Diamond, "&
[Book2]Sheet1!$E$3 & " Color, " &[Book2]Sheet1!$F$3 & " Clarity. " &
[Book2]Sheet1!$B$3 & " Certified. "
=[Book2]Sheet1!$G$4&" ct " &[Book2]Sheet1!$C$4& " Diamond, "&
[Book2]Sheet1!$E$4 & " Color, " &[Book2]Sheet1!$F$4 & " Clarity. " &
[Book2]Sheet1!$B$4 & " Certified. "

thanks so much!