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.

  • 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 '14 at 3:26
  • I wish I could copy and then paste but I know no way of referencing external cells by copy/paste – Steve Weaver Oct 1 '14 at 13:11

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.