Copy from another excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I copy cell range A1:H1 from excel file X to cells range A1:H1 in excel file Y.

But then, when I simply try to copy cells range A1:H1 in file Y to
A2:A199,H2:H100
to create the same connection of cells in Y with cell in X it does not copy
appropriately. in other words, it still copy range A1:H1 ..and shows copied
cells as $A$1:$H$1....

when i tried to eliminate $ sign, it showed in the cell the formula-link
itself instead of actual number

how to make parallel copying from another excel file work ?
 
Hi
not really sure what your issue is?
normally it sould be sufficient to enter
=
in a single cell and locate the source cell in the other file with your
mouse. After this hit ENTER.
Now you can copy this formula around :-)
 
Back
Top