In my opinion, you are not even close to being almost there, because that
is a completely different problem. But if you feel you are, then continue
on on your own.

If you want to think the problem through and provide a complete problem
statement, then someone may be able to help if you feel you need it.

There is no sense attempting code until the real situation is revealed.

for consideration, if several rows are missing, then the ones that are
present are not in the assigned locations. It would be important to know
what the end result should be. Will the first occurance of any of these
values be in at least row 15 - if not, then what to do - insert rows until
it reaches 15? What you state implies that the list could be taken and
pasted starting in A15 and they would line up in the proper rows (not
suggesting this as a solution, but to identify where each should end up).

--
Regards,
Tom Ogilvy


"alexm999 " wrote in message
...
Looks great and im almost there...

The file where i access the information holds the names DDC, DDCE,
etc... are in specific rows A15,A16,A17 and so on. I'd like my macro to
add a row if one of the names are missing. But if DDC,DDCE,DEV are
mentioned but DTS is not there, i'd like it to add a blank row to
compensate for the missing info...


---
Message posted from http://www.ExcelForum.com/