Copy from another excel file

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 ?
 
F

Frank Kabel

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to get IF(OR) formula to recognize multiple cells 7
How to add formula calling up current workbook when sheet copied 6
data from multiple files: best way to extract 1
Macro to copy & paste-special-values data to selected worksheets 1
Excel VBA help: Text file formatting 19
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Microsoft Excel 2007 - VBA To Sort Table And Copy To Another Sheet 2
Copy data from one Excel spreadsheet to another 2

Top