Most valuable professional
  • Hot Topics

Excel Direction for a VBA Logic loop to clean data

I have 159740 lines of data that look simular to this below, item number the next line or several lines locations numbers. I am think possibly some kind of a loop but looking for a starting direction. to put the data into a table file to work with. Any thoughts how to do this?? Thanks Sheet1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Excel tables to the web >> Excel Jeanie HTML 4

This question generated 33 answers. To proceed to the answers, click here.

This thread is current as of January 10, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel