Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro - select and paste
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - select and paste | Excel Worksheet Functions | |||
Macro - select and paste | Excel Discussion (Misc queries) | |||
Need a macro to Copy a selection and paste into a new email. | Excel Discussion (Misc queries) | |||
Restarting a macro | Excel Worksheet Functions | |||
Macro pulling data from 2 worksheets | Excel Discussion (Misc queries) |