auto copy&paste

  1. J

    Simple Tweak Required for Excel VBA while Copy rows to different sheets

    Sub CopyRowDemo() Dim Rw As Long, LstRwRaw As Long, NxtRwDest As Long Application.ScreenUpdating = False LstRwRaw = Sheets("Raw Data").Cells(Rows.Count, "B").End(xlUp).Row For Rw = 3 To LstRwRaw With Sheets(Cells(Rw, "B").Value) If .Range("B6") = "" Then NxtRwDest = 6...
  2. J

    Copy rows to different sheets if sheet name matches with Text of A column Tweak required

    Sub CopyRowDemo() Dim Rw As Long, LstRwRaw As Long, NxtRwDest As Long Application.ScreenUpdating = False LstRwRaw = Sheets("Raw Data").Cells(Rows.Count, "B").End(xlUp).Row For Rw = 3 To LstRwRaw With Sheets(Cells(Rw, "B").Value) If .Range("B6") = "" Then NxtRwDest = 6...
  3. N

    Auto Copy Data from Excel Workbook Based on Criteria using VBA

    Hi All, I want to automatically copy data from an old Excel Workbook into a new workbook based on criteria using VBA. I already found a good example of this here: Copy Data to Another Excel WorkBook Based on Criteria Using VBA | Excel VBA Training Videos However, this example puts the VBA...
  4. C

    Does Excel have IF THEN and automatically copy paste functions?

    Hi everyone:) I have a set of data that looks like: <tbody> From To Cost 0 1 10 0 3 11 0 4 15 1 2 6 1 5 1 2 1 3 2 4 1 3 ... ... ... ... ... 4 ... ... 4 .. ... </tbody> And it goes on. Question: is there a way that excel can do ---> IF B2 =1 THEN copy A5, B5, C5 and...
  5. L

    Automatically copy and paste into next tab on condition (which is automatically created on daily basis)

    Hi all I have an enquiry here and would like a workaround. I am an IT support consultant and want to maintain my own report of the issues I receive daily. I would like to have a spreadsheet with tabs created daily. E.g Each tab is created once daily and named as '2014-06-10', '2014-06-11'...
  6. M

    autofill and autocopy of cells from other worksheets

    Hey everyone, Can anyone please tell me how to do this? Just bear with me until I explain what I need to do. Thanks and... here we go! :) I have 1 MAIN worksheet that is named TOTALS and 12 secondary worksheets (one for each month of the year) that are called.... January, February, etc. Now...
  7. L

    running a macro if a set value is present and...

    Hi All I think I have a new one, have searched this forum far and wide.. Any help would be highly appreciated! What I am trying to achieve is for a preset range of data to be copied into a column depending on the value selected from a drop down box. The below screen shots will hopefully show...
  8. S

    VBA Script to automatically copy & paste data from multiple worksheets to a master sheet

    Looking for a vba script to automatically copy & paste data from multiple worksheets to a master sheet named Returns. The data that I need to copy resides in columns A through N on multiples sheets. These sheet names are Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec. However I do...

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