detweiler
Board Regular
- Joined
- Aug 2, 2013
- Messages
- 62
I run a report from out asset tracking system to find those items where the information has been incorrectly entered into the record. There are seven ( 7 ) columns that are in play,
PrimaryID PrimaryName Product HostName FriendlyName DBName Model
The issue is that there are several instances where the PrimaryName cell is empty, but any one or more of the five ( 5 ) columns to its right may have data that can be used as a temporary identifier for the PrimaryName cell for that record.
The problem is that, if the PrimarName cell is empty, I would like to copy the next cell to the right with data into that cell, meaning the Product cell could be empty, but the HostName cell might have data, or could be empty and the FriendlyName cell might have the data... I think you get the idea.
Is it possible to navigate this mud hut and, in the end, be able to format the copied to be italicized and the cell filled in yellow?
PrimaryID PrimaryName Product HostName FriendlyName DBName Model
The issue is that there are several instances where the PrimaryName cell is empty, but any one or more of the five ( 5 ) columns to its right may have data that can be used as a temporary identifier for the PrimaryName cell for that record.
The problem is that, if the PrimarName cell is empty, I would like to copy the next cell to the right with data into that cell, meaning the Product cell could be empty, but the HostName cell might have data, or could be empty and the FriendlyName cell might have the data... I think you get the idea.
Is it possible to navigate this mud hut and, in the end, be able to format the copied to be italicized and the cell filled in yellow?
