copy 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...

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...

: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...

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)...

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...

<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...

<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...

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...

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?