I know I'm probably asking 10 different questions within one post, but I'm such a newbie when it comes to macros that I don't know how to break it down more so that I can Google the answers..

CCSV.xlsm

Attached is a small part of what I'm working on.
I have this giant master sheet with somewhat condensed headers, but I need to copy over all the data to a new worksheet with different headers..

The third column of Sheet1 ("Analyte") has four different variables, but when I copy to a new sheet, I need each of the four variables to be in their own column (example would be in Sheet3). The corresponding "Week" number (column 5 of Sheet1), "Sample_Point" (column 4 of Sheet1), and "ANALYSIS_FINALRESULT" (column 1 of Sheet1) needs to match with the appropriate "Analyte" point. For instance, from Sheet1, Sample_Point RA should have four Analyte values for Week 0.33 (one each for Ca, K, Mg, and Na). I don't want the same week number for the same Sample_Point to show up four times in the new worksheet.

I don't know where the issue is in here, but if someone could help me out, or guide me to another thread that answers some of my questions, I would be so grateful!

Please Login or Register  to view this content.