Macro - select and paste

Giganews Newsgroups
Subject: Macro - select and paste
Posted by:  Rashid (syedjame…@sympatico.ca)
Date: Sun, 21 May 2006

Hi All,

The following is my weekly reconciliation spreadsheet. I need help with a
macro to do the following.

A          B        C      D      E    F        G      H      I
Order#    B9      IH    Bal        Check    Qty    Kgs    $
12709    12,325      0    1,235        X        (188)  (767)  (2117)
98069    50,001  (4,009)  1,024        X        (110)  (898)  (213)
82305    10,310      0    1,030        -          0    0        0

1) Select column A and search for duplicates, if found put and "dup" in
column E
2) IF THERE IS "X" IN COLOUMN F THAN MAKE THE ENTIRE ROW BOLD
3) COPY THE ENTIRE ROW DATA FROM column A TO D
4) PASTE ROW DATA (Col A to D) IN SHEET 1
5) ALSO COPY THE CELL Cell A and cell I and paste in colunmn J AND K
6) convert the sign of of the value. That is if negative convert it into
positive and vise versa.

THANKS,

RASHID

Replies