Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
How to make a macro who will, depending on code and values in sheet1
decrease value of same code in sheet2 and copy value of cell d1, Sheet1: A B C D 1 M009/05 2 1234 5 3 2345 1 4 5678 2 (Note: value of cell D1 is 9 but format is "M"000"/05" - p.s. number is increasing automatic, that is ok) -------------------------------------------------- Sheet2 (Before): A B C D E 2 1234 100 M001/05; M002/05 (Existing values) 3 2345 100 M006/05 4 5678 100 Sheet2 (After): A B C D E 2 1234 95 M001/05; M002/05; M009/05 3 2345 99 M006/05; M009/05 4 5678 98 M009/05 Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |