1

I am working on a budget spreadsheet in which I have to pull in cell data from another external spreadsheet. I have to do this for several different sheets with massive amounts of data in the sheets, Is there a better way of referencing the cells than opening both workbooks, hitting '=' in the cell to add the data to, and then double clicking the cell in the spreadsheet cell I'm pulling the data from? Is it possible to pull in an entire row at once? By the method I mentioned, I have to do one cell at a time and it is taking forever. There has to be a better way. Any help is greatly appreciated.

2
  • If they are contiguous cells, like you described doing a row at once, can you create the first cell and then copy it across the range?
    – fixer1234
    Oct 1, 2014 at 3:26
  • I wish I could copy and then paste but I know no way of referencing external cells by copy/paste Oct 1, 2014 at 13:11

1 Answer 1

1

If you create the external reference or the first column in the row, then edit the formula to remove the dollar signs. Then you can copy the formula into new cells (or fill right) and it will update the formula automatically.

1
  • Holy cow.....thank you so much! You guys have no idea how much time you just saved me!!!! That works like a charm. Oct 1, 2014 at 17:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .