copy between worksheets

  1. S

    Complicated "Mirroring" of dynamic cels between worksheets...

    Phew... Okay, guys: I've got a Frankenstein of a workbook that keeps track of employees (Each employee has their own tab) and their incidents/errors/attendance issues. There is a "LOG" (wsSource) sheet that I use to: Input data (Reporting Date, who is reporting the incident, incident...
  2. WERNER SLABBERT

    vb to check one sheet against another and copy a field from the third.

    ok lemme Try and explain this. sheet1 has a formatted layout. cell colour functions and so forth. sheet2 has the data table. sorted according to column "A" sheet3 has a blank formatted "template" for data on sheet1 say for argument sake. sheet1 has 190 "pages" of these formatted layouts. each...
  3. T

    Autofilter does not work when filter returns nothing

    :confused:Hi all: I would really appreciate your help. I have been struggling over this for some time. I am trying to filter several source sheets and copy the filtered data to several destination sheets in a loop. The autofilter works fine when the filter returns some data. The autofilter...
  4. H

    Copy between Sheets

    Hi, I have data in Sheet1 of the Excel sheet. I want to copy the content of Column C & D of Sheet1 into Sheet2 using a macro. I am able to do using below logic (But i think there is a simple logic): Get the Last record count of Col C For i=1 to Last sheet2.columns(r,c)=sheet1.columns(i,3)...
  5. D

    Copy the ActiveCell row into another worksheet

    I need the VBA code to copy the ActiveCell Row into the Worksheet called Cancellations. I need to copy the row onto a new line everytime in Cancellations. I tried ActiveCell.copy (Cancellations!), but this would not work, and it would only copy the ActiveCell, but I want the whole row that...
  6. P

    Match, cut & Paste

    <TABLE style="WIDTH: 213pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=284 border=0 x:str><COLGROUP><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5449" width=149><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><TBODY><TR...
  7. P

    match formula in vb

    <TABLE style="WIDTH: 213pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=284 border=0 x:str><COLGROUP><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5449" width=149><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><TBODY><TR...
  8. F

    Copying filtered data across sheets.

    Hi Guys, I have a workbook which has multiple sheets and a summary sheet. Lets say I have 11 sheets on the workbook with the first being my summary and the other 10 being pages with my data. On each of my data sheets there are columns which then have rows filtered based on critea for each...
  9. J

    Macro for copying cells with specific value in them to another worksheet

    I am trying to copy a row of cells from one worksheet to another worksheet if the value of the first cell in the row is a specific letter/number. Does anyone know the macro code to do this?

Watch MrExcel Video

This Week's Hot Topics

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
Top