Macro - select and paste

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
 

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

Similar Threads

Macro - select and paste 1
Create if partial match then copy and paste data from one cell to another 1
Loop thru sheets copy and then paste in other sheet 2
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1
Excel Autofilter Copy and Paste with Changing Values 0
Copy, re-order, and Paste macro 2
Insert rows by group and copy value 2
Macro - copy and paste value 3

Top