I need help and guidance on how:-
to create 50 Word reports using including data for 50 specific data sets - ‘Locations’. I also need a similar report with the Totals for all 50 Locations.
I have a spreadsheet with 50 rows of data (text and numbers) – one for each Location. So far so good – I can use Mail Merge.
I have some spreadsheets tables which use data unique to each Location and calculates projected Costs over a 10 year period . I want to be able to include this table – unique to each Locatin - into my Word report so that it picks up the whole table of 10+columns and 20+ rows (Cost items). I do not want to manually copy it in Location by location.
I am hoping that I do not need to create 200 columns on my Locations spreadsheets and then create merge names for each field on the table. In fact I will have a couple of this type of table to merge so it would be a laborious work around.
I don’t know how to do this correctly and need advice as Im sure there is a solution
I use Word and Excel. I do not have the luxury of time to learn about databases - though I am happy to learn about more advanced Excel techniques.
Though not essential I would also like to merge images/photos unique to each of the locations in each of the Word reports without manually copying them over.
8 фрілансерів(-и) у середньому готові виконати цю роботу за £19
I have read your information, I would be happy if I could do whatever you want, and if you give me your information I will be able to transfer your data to a word file within a specified timeframe.