lrw

  1. A

    Copy rows with data to another workbook

    Hi I have the below code to copy rows with data from one workbook to another ignoring the first two rows as these are header rows however it is only copying column 1. Where am I going wrong? Sub Export_data() Dim ws As Worksheet, wb As Worksheet Set ws = Sheets("Triage") Set wb =...
  2. A

    run time error 9

    Hi I have the below code to copy data from one workbook to another but keep getting a subscript out of range error on the line... Set wb = Workbooks("2019_-_Couriersheet_-_copy.xlsx").Worksheets("Triage2") Both workbooks are open and I've checked the file name is correct etc. What could the...
  3. R

    Collate the data from excel when it is opening

    Hi Team, I am stuck in a scenario where Superviosor need to collate the data from all team, twice or thrice in a day. Below is my code which is working fine if the file is closed and we want to collate the data with all type of excel whether user is working on this file or it is close. I am...
  4. A

    VBA to extract unique values based on two criteria and paste it to another sheet

    Hello All, After going through numerous posts, I have managed to put the following code together that helps me in extracting unique values from Sheet 1 Column C into Sheet 2 column A. What I am trying to add is a condition for unique values only for a date that user will be asked to enter. I am...
  5. T

    Clear Row Contents (Excluding Column A & N)

    Hi All I have the following code that clears the contents of a row based on the text in cell G. However I need the code to clear contents of the row but exclude anything in Column A and N. Sub ClearIncorrectRows()Dim lRw As Long, n As Long lRw = Range("G" & Rows.Count).End(xlUp).Row For n = 1...
  6. TryingToLearn

    MoveAfterReturn does not function on protected sheet

    Excel 2016 on Win10 Activating the workbook turns moveafterreturn to false & immediate window confirms this is correct. for coding on the sheet to work properly the cell being changed needs to be the active cell. If the sheet is not protected, all works fine. If the sheet is protected, all...
  7. T

    Macro to drag formula from Activecell to last row used

    I am stuck on figuring out on how to fill down my formulas from the activecell selection to the last row used in column AK. Please keep in mind that the active cell can always be in a different spot of the excel spreadsheet. Dim LRw As Long ActiveCell.Select ActiveCell.Formula = "1" LRw =...

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