Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2022, 11:24 PM
macropod's Avatar
macropod macropod is offline How to Draw a line at every change in date in the document Windows 10 How to Draw a line at every change in date in the document Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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


I suggest you check the before & after screenshots more closely. With 01-08-2018, for example, you'll see that all dates are now aligned to the top of the cell and, where it previously didn't, the first line of each multi-line cell has been moved to the previous row (see especially the narration column).

The process relies on the affected rows having two or more paragraphs in each cell, so it isn't foolproof and the results will still need visual checking, particularly for the cheque column.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-23-2022, 08:19 AM
RAJESH@1960 RAJESH@1960 is offline How to Draw a line at every change in date in the document Windows 10 How to Draw a line at every change in date in the document Office 2019
Novice
How to Draw a line at every change in date in the document
 
Join Date: Oct 2022
Location: INDIA
Posts: 13
RAJESH@1960 is on a distinguished road
Default

I checked the data after running the code. Only that particular row is right. All the other rows are not affected by the code. This is just a sample data. Imagine where there are more than 500 rows of data, then I will have to clean each and every row to get it right. If the sample data works accurately, I could try it on the original data.
As the document is converted into pdf and I am trying to convert the pdf to document once again, there has to be some way to get each transaction separated from each other at each change in date. I am just trying to know and understand the pattern how it was done.
The option in word document is also giving the same result if I convert it to table.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw a trendline but not show the original line? Sunny Rio Word 0 09-03-2022 05:55 PM
How to Draw a line at every change in date in the document How to draw a cross mark on a vertical line? kingston123 Drawing and Graphics 4 09-19-2018 03:44 AM
How to Draw a line at every change in date in the document How to draw double line border for a Cell phamh PowerPoint 2 10-21-2014 02:26 PM
How to Draw a line at every change in date in the document I draw a line, an arrow comes up instead ZapoTeX PowerPoint 1 11-06-2012 02:03 AM
How to Draw a line at every change in date in the document how to draw line diagram with x yr yl gsrikanth Excel 1 03-07-2012 05:50 AM

Other Forums: Access Forums

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