Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-15-2024, 01:50 AM
raamkrish raamkrish is offline Need a macro to change the table data in ms word 2016 Windows 10 Need a macro to change the table data in ms word 2016 Office 2007
Novice
Need a macro to change the table data in ms word 2016
 
Join Date: Dec 2019
Location: chennai
Posts: 2
raamkrish is on a distinguished road
Default Need a macro to change the table data in ms word 2016

Hi all



i have a word document in that i have to change the table values using a macro instead of copy/paste.

i have a table like this (1row and 5 columns)
1 SERVICE CHARGE 2,000.00 0.00 2,000.00

but i want to change the table in to 2 rows and 5 columbs like below
1 WATER WASH 500.00 0.00 500.00
2 GENERAL SERVICE 1,500.00 0.00 1,500.00

regards
raamkrish
Reply With Quote
  #2  
Old 08-15-2024, 06:31 AM
macropod's Avatar
macropod macropod is offline Need a macro to change the table data in ms word 2016 Windows 10 Need a macro to change the table data in ms word 2016 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For a single table, this would be way faster to do manually than for anyone to write a macro to do it. And, if you have multiple tables with different parameters, even that would be way faster to do manually, since we have no idea what all those parameters might be.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-15-2024, 09:01 AM
raamkrish raamkrish is offline Need a macro to change the table data in ms word 2016 Windows 10 Need a macro to change the table data in ms word 2016 Office 2016
Novice
Need a macro to change the table data in ms word 2016
 
Join Date: Dec 2019
Location: chennai
Posts: 2
raamkrish is on a distinguished road
Default

Thanks for your reply.

I am creating building block for each and every table and using it on daily work.

Looking for a code like find and replace method, that adds a additional row and updates the data in rows
Reply With Quote
  #4  
Old 08-15-2024, 04:05 PM
macropod's Avatar
macropod macropod is offline Need a macro to change the table data in ms word 2016 Windows 10 Need a macro to change the table data in ms word 2016 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Adding another row doesn't require a building block. For a basic table, all you need do is click on the table and choose Table Tools|Layout>Insert Above or Table Tools|Layout>Insert Below.

If you want to replicate a table row containing content controls before the last row in a table, see, for example:
https://www.msofficeforums.com/word-...html#post87989
https://www.msofficeforums.com/word-...html#post38461
https://www.msofficeforums.com/word-...tml#post145675

Beyond that, it's impossible to code for something as vague as "updates the data in rows".
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a macro to change the table data in ms word 2016 cannot enter data into table cells in word 2016 jalea148 Word Tables 5 06-03-2018 04:05 PM
Change left sidebar with macro in Office 2016 swenniels Word VBA 0 03-19-2018 11:52 PM
Need a macro to change the table data in ms word 2016 Dimensions of a Table Created in Word 2013 Change when saved in Word 2016 PKW57 Word Tables 2 05-26-2016 05:15 AM
Macro to pull data out of a Word table shanemarkley Word VBA 20 05-07-2015 01:36 PM
Want to change Macro to copy and paste data to new sheet Vortex69 Excel Programming 0 12-23-2014 09:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 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