Discussion Locked

How do I import data from another excel

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I wish to import data from a client's file and enter this info into a client base in another excel folder.say info is in Smith.xls sheet 1 cell A3 and I wish to import into Total/Clients base file c3 cell sheet2 How do I do it?

4 replies

by gurnerworld

The easiest way would be to open both sheets, put the cursor in total/clients base file, sheet 2, cell c3 and press =. Then click on sheet1, cell a3 in smith.xls.

by ttellefsen

I would open up the clients file go to the sheet highlight the cells you want to copy then open your file go to the cell then do an edit paste link in your file that way anytime the clients data changes so will yours without ever having to copy again.

This discussion is closed to new replies.