Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
20152019 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
  #2  
Old 03-24-2023, 09:28 AM
Charles Kenyon Charles Kenyon is online now Monthly Report - automatic filling of txt from copied tables Windows 11 Monthly Report - automatic filling of txt from copied tables Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 8,803
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Look into using Mail Merge.
Mail merge using an Excel spreadsheet - Word
Reply With Quote
Reply

Thread Tools
Display Modes


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 08:19 AM.


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