transpose in vba loop

  1. S

    Excel Macro to Transpose the Data

    Hi, Can anyone help on the below macro code. I have the data like below, <tbody> Name ABC Model DEF City GHI Place JKL KM Condition MNO 1st Owner 2nd Owner PQR 3rd Owner Price STU Delivered 11111111 Name XYZ Model DJFHA City SAHJA Place SHJ KM Condition...
  2. H

    Urgent--macro for transposing data

    Hi there, Im trying to create a Macro which can do the following: Start selecting from a1 till blank column and coming down till blank row cell by cell , select the all above values, copy them and paste them by transposing them AFTER tWo blank columns, carry on doing this procedure and...
  3. M

    How to transpose data across worksheets into one Analysis sheet

    Hello, I've used the following formula successfully to pull data from multiple sheets and provide the total on an analysis worksheet. Example of worksheets and formula. =DSUM(INDIRECT("'"&A2&"'!D:D"),$B$1,INDIRECT("'"&A2&"'!D:D")) Example of one of the individual sheets holding original data...
  4. E

    Import data Transpose in VBA loop

    I m new to macro and I need to copy the data from row 26:27, 36:37, 46:47 cells value which are converted into E9:F39, P9:Q39, AA9:AB39, 12 columns in the other workbook. How can I do if I want to import the data directly instead of making a copy of the report inside of my workbook by using...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top