MACRO to get the desired fields and copy to the other sheet

**Ca5m** · 08-24-2012, 01:49 PM

Hi All,

Please I really help now.. If some one can please help me with this report..... I browsed the forum and stumbled on a macro that might be useful or might be the same with the report I am currently am working with but was unable to edit it...

If it is possible, can some one help me today... because it is urgent... Can someone build me a macro which can get only the desired data in the RAW sheet to the Report sheet.

See sample sheet.

Attachment 176380

Thanks

CAMILLE

**john456852** · 08-24-2012, 02:44 PM

ain't work

---------- Post added at 02:44 PM ---------- Previous post was at 02:43 PM ----------

can't open attachment
send again

**Ca5m** · 08-25-2012, 05:29 AM

My apologies. .. . Thanks for the response.

EWFMCOACH.xls

**Ca5m** · 08-28-2012, 11:55 AM

I placed some sample data in the sample worksheet. Can you help me? please. . . .

**Ca5m** · 09-01-2012, 05:04 AM

anyone. . . .. help. . . .. . badly needed....

**arlu1201** · 09-01-2012, 05:17 AM

Will the information from one employee to the other always have the same number of rows?

**Ca5m** · 09-05-2012, 11:57 AM

yes it will arlu1201!

**arlu1201** · 09-05-2012, 01:32 PM

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button