anbarasi_r
New Member
- Joined
- May 19, 2015
- Messages
- 7
Hi,
I'm looking for a macro code that copies certain rows from sheet1 to sheet2 when data is selected in combo box which will be placed in sheet2.
Eg: Sheet1 has following columns. ColA-name, ColB-active/inactive, ColC-Apr, ColD-status, ColE-on/off, ColF-Bill(0-1 numbers), ColG-code, ColH-May, ColI-status, ColJ-on/off, ColK-Bill(0-1 numbers), ColL-code, COlM-Jun and so for all months. There should be a combo box in sheet2 used for selecting different months like apr, may or june. When a month(may) is selected, only columns A and Columns I to K should be displayed in sheet2. And for rows that contain ColK if number is less than 1, ColL if code is 435 and colJ if the previous month has ON and current month has OFF or viceversa should be displayed.
Please help with the code.
Thanks in advance
I'm looking for a macro code that copies certain rows from sheet1 to sheet2 when data is selected in combo box which will be placed in sheet2.
Eg: Sheet1 has following columns. ColA-name, ColB-active/inactive, ColC-Apr, ColD-status, ColE-on/off, ColF-Bill(0-1 numbers), ColG-code, ColH-May, ColI-status, ColJ-on/off, ColK-Bill(0-1 numbers), ColL-code, COlM-Jun and so for all months. There should be a combo box in sheet2 used for selecting different months like apr, may or june. When a month(may) is selected, only columns A and Columns I to K should be displayed in sheet2. And for rows that contain ColK if number is less than 1, ColL if code is 435 and colJ if the previous month has ON and current month has OFF or viceversa should be displayed.
Please help with the code.
Thanks in advance