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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top