View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
D.Parker D.Parker is offline
external usenet poster
 
Posts: 31
Default Shift Rows Up After Row Deletion and Continually Repeat

Hello! I would greatly appreciate your expertise on opening up a text file
and deleting rows of data if they do not meet the format of "0.0", "1.0",
"2.0", etc. After that delete any empty rows and shift the rows up to form a
consecutive numbering sequence in column A. The order of operations should
not matter as long as it is efficient, the total number of rows I'm working
with is ~7K. Your time and expertise is greatly appreciated.

Kind regards,

D.Parker