Macro - select and paste

  • Thread starter Thread starter Rashid
  • Start date Start date
R

Rashid

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
 
You can probably do this without resorting to macros.

To mark the duplicates use

=IF(COUNTIF(A:A,A1)>1,"dup","") in D1 etc.

The copies can be done with a simple =

Changing signs can be achieved with =-
 
Back
Top