Hittting a wall with this one. I need to script that can take the data from sheet1 and format it on sheet2. Sheet3 shows what data is desired and how it should be formatted, and sheet1 needs to remain intact. I haven't had any luck on my attempts getting it right, hoping that someone smarter than me can figure it out. thanks in advance, s4