Posts by johndrew982

    The stock data I have comes in row format. I need a Macro to transpose it so it is in Column format. The data always starts at A3 and I take the next 11 rows. Then I transpose it to Sheet 2 starting on Row 2. Row 1 are the Headings. Then I need the macro to return to Sheet 1, add 13 to the last row number used and repeat: copy and transpose to the next row in Sheet 2. Continue until it reaches a blank in column A. Ozgrid Transpose Stock Data.xlsx

    Here is the code I used. I changed the To: addy to Johndrew98@gmail.com. When I dubug it has .SEND hilighted in yellow.


    OZGRID TEST EMAIL.xlsm

    I only changed the email address to mine. Now I get send using configuration value is invalid. It highlights .send in yellow.