Im trying to find a script that will remove a row (shifting subsequent rows up) if one of the cells in the row (there are 2 columns) is blank.
Im creating table based docs using datamerge and there are rows with dataheadings (in column 2) and the datavalues (in column 1) for the rows are imported via the merge. Not every heading has a value so I want a script to remove the rows where no value is present.
I have found scripts that work however due to the end text # markers that are left after the merge I think they see the cell as being populated.
Thanks for you help
@Angus – do you need the markers?
If not, do a TEXT Search/Replace and remove them (replace by nothing).
The code you should enter for the search would be:
Then run your script.
Uwe. You are a bloody lifesaver!!!
It works absolutely perfectly
Many, many thanks!!!!!