I am hoping to learn how to auto populate from one sheet to another so I can enter data once, but use the same data in a number of different sheets. I'm sure this is simple, I just don't know how.
Thanks
Chan
I am hoping to learn how to auto populate from one sheet to another so I can enter data once, but use the same data in a number of different sheets. I'm sure this is simple, I just don't know how.
Thanks
Chan
Hi Chan,
Welcome to the forum.
Either you can use lookup functions (vlookup, index-match etc) or you can link the data to various sheets... upload the sample file after which I can suggest better. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks