First, my apologies for maybe not clearly explaining what it is I'm struggling with in excel and not doing this in my subject line (also, I hi-jacked a 10yr old thread...doing well, doing well).
I'm working with item numbers, dates and order amounts of the item number by dates with two different sheets in one excel file. In sheet1, Column A are the item numbers and starting on A3. In Row 2, starting on B2, the first date, which goes daily across for 20 days. The dated columns are not always next to each other, but they are all on Row 2. In the "spreadsheet" are the necessary amounts of items to order by date, some instances, 0 will be filled.
So, I'm trying to find a VBA that will pull the dates from sheet1, Row 2 and transpose to sheet2 Column A. The next column would be the item number followed by the necessary amounts, SKIPPING the zeros.
Examples attached of before and after or sheet1 (original) and sheet2, which explain what I'm trying to accomplish.
Thanks in advance!