Data input from Excel (.xlsx), from different rows and cells.

[no spam]

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.

[Old Bruce]

There is the Data Merge tool and functions.

[walt.farrell]

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.

[no spam]

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.

[thatGuy]

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

[no spam]

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.