#newbie

  1. K

    VBA-Macro Help with copy data from 1sheet into another sheet multiple times

    Hi Mr. Excel, I need a logic that would copy Sheet1 (Data Table) into Sheet2 Sheet2 (End Result should look like this) In this sheet, MaterialA should be repeated 13 times and each of the months values should be copied vertically against the respective month. I needed help on how to do this...
  2. A

    Create multiple rows for multiple data points in the same attribute

    How can I create multiple rows when there are multiple data points for the same attribute? Thanks!!! For example, if there are 3 investors in company ABC, then there will be 3 rows ------------------------------------------------------------------------- <colgroup><col><col...
  3. A

    problem on transferring data to another workbook

    let's say here is my sample workbook ("productmovement") <tbody> Product Out Stock Total apple 5 8 3 banana 4 9 5 orange 3 10 7 </tbody> and here is my samlple workbook ("productinventory") <tbody> Product Stock date grapes 10 apple 8 orange 10...
  4. A

    Problem on identifying last row using excel VBA

    Hi, Im just newbie in excel VBA :) ActiveSheet.Range("A6:K" & Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row).SpecialCells(xlCellTypeVisible).Select using the code above its only selected 1,528 rows where it supposedly selected 2,092 rows which is my last row?:confused: is there a...

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