worksheetsdata

  1. M

    Sorting data changes all columns

    I did a transfer using VBA. I am having trouble now filtering the data and sorting it. I used the following in VBA: Sub Copy() Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("A5") Sheets("Data Entry").Range("A5:A654").Copy Sheets("Try1").Range("D5") Sheets("Data...
  2. D

    Need help turning my script into a loop

    Hey guys.....:) Is there a way to turn this into a loop?:confused: Worksheets("Data Entry").Select ActiveSheet.Shapes.Range(Array("Picture 2")).Select Selection.Copy Range("R2").Select ActiveSheet.Pictures.Paste.Select Worksheets("Data Entry").Select...
  3. A

    How to copy a cell from one worksheet to a cell in another?

    Currently have a user form and data table where new entries in the user form go to the end of the data table in a worksheet called "Data Inputs", with the following relevant code: Dim iRow2 As Integer Dim Data1 As Range iRow2 = Worksheets("Data Inputs").Cells(Rows.Count, 6).End(xlUp).Row + 1...

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