HI,
You'll need to give more info on how your sheets are set up, what sort of data you have, how the part numbers are assigned etc. An example would really help! Consider downloading the html maker addin from the link below this post & post up a representative snapshot of your sheet.
paddy