no spam Posted May 5, 2021 Share Posted May 5, 2021 Hi, I am provided Excel-workbooks (files) which have different data in each file, but always in the same cells and rows. I would like to import these and place them in a publisher file. This way each Excel file would get one Publisher file. Say, the clients name is in c4, the street address in d12 and so on.. Can I somehow „pick“ from wherever and have the Publisherfile be populated accordingly, nly changing the Excel sourcefile each time? Its for a kind of manual Invoicing which relies on a clients Excel sheets.. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
Old Bruce Posted May 5, 2021 Share Posted May 5, 2021 There is the Data Merge tool and functions. Quote Mac Pro (Late 2013) Mac OS 12.7.4 Affinity Designer 2.4.1 | Affinity Photo 2.4.1 | Affinity Publisher 2.4.1 | Beta versions as they appear. I have never mastered color management, period, so I cannot help with that. Link to comment Share on other sites More sharing options...
walt.farrell Posted May 5, 2021 Share Posted May 5, 2021 1 hour ago, Old Bruce said: There is the Data Merge tool and functions. Yes, but I don't think that mix data from different rows of the table as would be required by the question. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. iPad: iPad Pro M1, 12.9": iPadOS 17.4.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.4.1 Link to comment Share on other sites More sharing options...
no spam Posted May 22, 2021 Author Share Posted May 22, 2021 On 5/6/2021 at 12:06 AM, walt.farrell said: Yes, but I don't think that mix data from different rows of the table as would be required by the question. Exactly, it "only" goes row by row... which is good for its purpose. Quote Link to comment Share on other sites More sharing options...
thatGuy Posted May 22, 2021 Share Posted May 22, 2021 You could create a table that queries your data and puts it all in one row for use of the data merge tool, if all your data files are structured exactly the same you could just replace the data source each time and have everything ready to import to publisher Quote Link to comment Share on other sites More sharing options...
no spam Posted April 29, 2022 Author Share Posted April 29, 2022 On 5/22/2021 at 5:41 PM, thatGuy said: You could create a table that queries your data and puts it all in one row for use of the data merge tool, if all your data files are structured exactly the same you could just replace the data source each time and have everything ready to import to publisher Thats what I actually ended up doing. Created a new sheet and „colleted“ the data of these different fields into one row. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.