Robert -

I'd pull the data into Access instead, allowing Access to create an index
field. Let's say the table that Access creates is called RF (for radio
frequencies)

Then use a query like this:

SELECT Idx, Frequency, License, Type, Tone, Description, Mode, Null as Source
FROM RF
union all
SELECT Idx, INPUT as Frequency, License, Type, Tone, Description, Mode,
"Input" as Source
FROM RF
Where Input is Not NULL
order by Idx

Enter this query in Access by creating a new query in SQL mode


Frequency Input License Type Tone Description Mode


"Robert" wrote:

Yes it is imported from a website. I would like to run the macro after the
import is complete, it can be run manually, ideally it would do the output
into another worksheet keeping the data intact on the original sheet.

Thanks

Robert

"Duke Carey" wrote:

A formula cannot insert new lines or do any of things you want, except return
a TRUE/FALSE on the comparison of values. You really need a macro. The
queston, though, is what kind of macro?

Do you import this data from some other application, and you'd like the
results you describe to occur after the import is complete? If so, you want
to run a routine manually after the import is complete.

Or, does a user actually use Excel to key the Input values into the cells
you've described? If this is the case, do you want something to happen after
the users completes the input on a line, or when the user indicates that
he/she is finished with the input process? If the former, then you would use
an Excel event macro, called when a cell is changed. If the latter, you're
back to running a routine manually when the user says to.

Post back with some more details, please!