#1
|
|||
|
|||
Monthly Report - automatic filling of txt from copied tables
I have a monthly report due which includes tables from a spreadsheet generated in Excel. I want to be able to paste new data in a table and have it automatically update the txt. Here is an example:
Txt: Daily flows averaged 47.09 kilo cubic feet per second (kcfs), compared to 73.15 kcfs in 2020 and 109.31 kcfs for the 2015 to 2019 average. Daily spill averaged 29.93 kcfs, compared to 47.45 kcfs in 2020 and 40.13 kcfs for the 2015 to 2019 average. Table (this didn't copy over correctly but you get the idea, I want to link: Date Weekly Average Flow Weekly Average Spill Weekly Average Temp 2021 47.09 29.93 50.4 2020 73.15 47.45 50.6 2015–2019 Avg. 109.31 40.13 51.1 Again, the idea is to copy the data into the new tables in word, and the txt is updated with the new data. Any help? |
#2
|
|||
|
|||
Look into using Mail Merge.
Mail merge using an Excel spreadsheet - Word |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tables and automatic picture resize | DanTowns | Word Tables | 3 | 04-19-2018 04:50 PM |
Automatic Report Writer | MatthewBragg | Excel | 0 | 01-04-2018 07:40 AM |
Projects Cash Flow Report in Excel not creating monthly data | gardwr | Project | 2 | 09-02-2013 09:10 AM |
Making Tables Copied from Excel Fit to Page | joatmon | Word | 1 | 05-30-2012 08:47 AM |
Manager On Duty Monthly Automatic Schedule | erwinar | Excel | 2 | 11-30-2011 09:09 PM |