So I have this spreadsheet and I have names, so everybody's name that's there. So I just wanted to look at what we have in this file itself. And again, if you don't have Excel that's alright because a lot of times you're just given this Excel file or what we really wanna end up with is a CSV file which we'll do in a second. We can go back to the finder and I started with this Excel file. So let's actually look at what we're starting with. I accidentally linked my CSV file and now it keeps looking for it. So I need to go into my blank one, which I don't have anything for. And what I wanna do is I wanna be able to lay one out and have it populate with all the other ones that are here. This is what I'm going to try to end up with here. And let's actually look at what I am going to create. So we're going to use data merge for that. So think of like if you had an Excel file that has all your part numbers in it, so all your parts, all your part numbers, all the descriptions, maybe the price, and also photos for that and you want it to automatically create a layout for you on the fly, we can do that. But it is what it is, we're merging data and what I'm going to do is I'm going to take data that I have in an Excel file and I'm gonna use that to help automate my layout. The next thing we're gonna go over is data merge which sounds boring, again, sometimes I think we just need to come up with our own naming on some of these operations that we do.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |