View original (French)

Fill an Excel sheet from another table

Solved
fardzo -  
fardzo Posted messages 12 Registration date   Status Member Last intervention   -
Hello dear internet friends,

I come to seek your help on Excel. I have two tables on two different sheets and I would like to automatically fill the one on the second sheet.

Does anyone have a solution? I'm not very good with Excel, and if someone is willing to give me lessons, I'm ready to pay.

See you soon ;-)

Configuration: Windows 7 / Internet Explorer 8.0

7 answers

Answer 1 / 7
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   834
 
Hello

For example, on sheet 2, you can put an equal sign in a cell, then go to the sheet with the cell you want to retrieve the information from and hit enter, and you will see that you have created a link between these two cells.
I hope I have helped you.

--
Practice makes perfect. - It's when you're up against the wall that you see the mason - one always learns from their mistakes.
2
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
If you want to automatically retrieve what is written in cell C12 of sheet 1 in cell G3 of sheet 2, simply enter the formula =Sheet1!C12 in G3.
0
fardzo Posted messages 12 Registration date   Status Member Last intervention  
 
Thank you, Philou, for your feedback. In fact, that's what I did; the problem is that the first table contains more information and therefore more rows than the second. So, when I drag the cursor, instead of getting the information from row 4, for example, on my second table, I get row 2 from the first.
0