Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or excelfunctions
Hey,
I have a problem in Excel and I think I have to write a Macro for that. But I have no experience in VBA. Maybe someone can help me out.. I have two sheets (A and B). I have too match these sheets on the base of some columns. If the columns match then I want to cut the whole line out of sheet B and paste it after the matched column in sheet A. Example Sheet A Sheet B 1 AA X1 4 BLA VLE K5 2 BB D2 6 GGG JJJ L9 3 CC V5 2 HJH HJH D2 4 FF K5 SheetA.Colum1 = SheetB.Column1 and SheetA.column3 = sheetB.column4 Results Sheet A SheetB 1 AA X1 6 GGG JJJ L9 2 BB D2 2 HJH HJH D2 3 CC V5 4 FF K5 4 BLA VLE K5 Thanks a lot Nic |
Reply |
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 end macro on inital active worksheet containing macro button that was clicked | 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 |