Hope Someone Can Help

[razorblade]

I have a Workbook with several sheets all of which are the same layout and 1 final sheet (Sheet6) which will give a list of all arrivals and departures.

I have dates along the top with Personel down the left side.

I need a macro or something that can look through sheets 1-5 on a specified column (date).

If there is an 'A'(Arrival) i need it to copy Column 'A', 'B', 'C' & 'D' into the same columns on Sheet 6. If it is an 'X'(Departure) i need it to insert Columns 'A', 'B', 'C' & 'D' into 'F', 'G', 'H' & 'I' on sheet 6.


Hope someone can help. I can send a dummy copy of the workbook to anyone if they want to have a play around and understand better.

Sorry for the lame description


Many thanks in advance

David

 

[onlyadrafter]

Hello,

From the relevant spreadsheet, select TOOLS --> MACRO --> VISUAL BASIC EDITOR, a new window will appear.

Select VIEW --> PROJECT EXPLORER (this many already be open), in here you should see VBAProject (your spreadsheet name). If this has a + to the left, press it with the mouse and it should change to a - (if it isn't already).

You should now see

Microsoft Excel Objects
and all the sheet names.

select INSERT --> MODULE

Modules
Module1 will now be added and the large window will show (General) and (Declarations) paste the code in here.

GO back to the spreadsheet select TOOLS --> MACRO --> MACROS
change MACROS IN All OPen WOrkbooks to THIS WORKBOOK and select arrivals_departures.