Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro or VB?
Please help. I am in great need. I have an expense report. In cells A2:A10
I enter the expense codes. There can be blanks cells between codes entered. There can be several different expense codes. In cell I15 I need to copy the expense code entered in lets say A2. Then copy down from I16:I11 any corresponding data from row 2 for example Meals, Lodging and so on. I need to do this for each expense code. So lets say I enter a different code in A6. I would need to copy that code to the next column over, J15 then copy down the corresponding data from row 6 into cells J16:J11. Does any one have any idea how I might even begin to do this complex macro, VB or formula. Any help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |