I need help with an efficient method for taking my current selection of non-contiguous cells, then pasting onto another sheet all into one row. I attached a simplified version of what I'd actually apply this to. Each row I want to copy Column A through the column before the Date starts (which could be the same but will mostly change). Then I want to be able to copy that and paste it all to be in order in one row (on another sheet if that's necessary to know). I have not had the time to learn VBA, but am trying to make the time for it. Pretty much all VBA I've used has been found online and modified slightly for my needs. I tried looking all over this forum and couldn't find something close enough.
This is my first time posting here, so please just let me know if I can clarify or help in any other way.