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?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top