Ok, I am hoping I attached the file with the sample data properly. I need to rearrange the data on the sheet "file test 1" into the format shown on "Sheet 1". I have already created a macro to insert the header on "Sheet 1", so that does not need to be done, I just put it in their so you would know which column headings correspond to the data. This rearrangement is based on the code column. Each code will have a set number of attributes(the data following the code) and the number of attributes changes with the change in code. This is only a small sample but if I could have someone help with the coding of a macro for this sample I think I can modify it for the rest of my codes and attributes (approx. 200). The macro will need to work on a file of undetermined size, the end of which is signified by a empty cell in column A.
Any help will be much appreciated
Thanks
Devin
Bookmarks