C
Chris
Hi, could someone please help me with the following?
I have the following:
1. Worksheet named: Report has a dropdown list in cell B2 for a list of
Operations. These Operations are detailed
on Worksheet named: Operations. The defined name for these Operations =
Operations!$A$2:$A$12.
2. Worksheet named: Report has a dropdown list in cell B4 for a list of
Groups. These Groups are detailed on
Worksheet named: Groups. The defined name for these Groups =
Groups!$A$2:$A$29
What I need is a macro or code to do the following after the user has
selected both an Operation and a Group:
I need it to lookup column X for all the cells that contain the text:
"VACANT".
Then copy the entire rows (that contain the selected Operation, Group
and column X contains the text: "VACANT") and
copies the enire row or rows to a new workbook named: OMD Report.xls to
worksheet: named: Report.
If anyone could please help with this, it would be greatly appreciated.
Kind regards,
Chris.
*** Sent via Developersdex http://www.developersdex.com ***
I have the following:
1. Worksheet named: Report has a dropdown list in cell B2 for a list of
Operations. These Operations are detailed
on Worksheet named: Operations. The defined name for these Operations =
Operations!$A$2:$A$12.
2. Worksheet named: Report has a dropdown list in cell B4 for a list of
Groups. These Groups are detailed on
Worksheet named: Groups. The defined name for these Groups =
Groups!$A$2:$A$29
What I need is a macro or code to do the following after the user has
selected both an Operation and a Group:
I need it to lookup column X for all the cells that contain the text:
"VACANT".
Then copy the entire rows (that contain the selected Operation, Group
and column X contains the text: "VACANT") and
copies the enire row or rows to a new workbook named: OMD Report.xls to
worksheet: named: Report.
If anyone could please help with this, it would be greatly appreciated.
Kind regards,
Chris.
*** Sent via Developersdex http://www.developersdex.com ***