Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-24-2023, 07:40 AM
marksalmon marksalmon is offline Monthly Report - automatic filling of txt from copied tables Windows XP Monthly Report - automatic filling of txt from copied tables Office 2016
Novice
Monthly Report - automatic filling of txt from copied tables
 
Join Date: Mar 2023
Posts: 1
marksalmon is on a distinguished road
Default 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?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Monthly Report - automatic filling of txt from copied tables 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
Monthly Report - automatic filling of txt from copied tables 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
Monthly Report - automatic filling of txt from copied tables Manager On Duty Monthly Automatic Schedule erwinar Excel 2 11-30-2011 09:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft