bluefish44
Board Regular
- Joined
- Apr 3, 2009
- Messages
- 187
Hi All and thanks in advance for any help.
What I'm trying to do is create a macro that looks at a sheet called 'Pipeline' and pull selected rows from that sheet (based on 2 criteria) into an existing worksheet called 'Summary'.
In addition, there are only 2 columns from those selected rows I would like pulled in.
On the 'pipeline' worksheet there is a column B titled "Forecast Category", a column J titled 'Opportunity Owner, a column L called "Opportunity Owner" and a column P titled "Total Bookings (converted)"
If column B on the 'Pipeline' sheet says Closed, and column J on the 'Pipeline' sheet equals the name I have in cell $B$2 on the summary page, I want the macro to pull in the rows of data to the summary tab that contain all the rows of data for those two restraints. Instaed of the entire rows being pulled in I only want column L (Opportunity Name is the header) and column P (Total Bookings (converted pulled in). I would like this to be pulled in to the summary sheet going down starting in row 57 in columns B and C (Opportunity Name in column B and Total Bookings (Converted) in column C. So when the name in $B$2 of the summary sheet is changed, it will trigger the macro to put the data in the summary sheet.
My programming experience is very limited but trying to learn! Please let me know if you have additional questions
What I'm trying to do is create a macro that looks at a sheet called 'Pipeline' and pull selected rows from that sheet (based on 2 criteria) into an existing worksheet called 'Summary'.
In addition, there are only 2 columns from those selected rows I would like pulled in.
On the 'pipeline' worksheet there is a column B titled "Forecast Category", a column J titled 'Opportunity Owner, a column L called "Opportunity Owner" and a column P titled "Total Bookings (converted)"
If column B on the 'Pipeline' sheet says Closed, and column J on the 'Pipeline' sheet equals the name I have in cell $B$2 on the summary page, I want the macro to pull in the rows of data to the summary tab that contain all the rows of data for those two restraints. Instaed of the entire rows being pulled in I only want column L (Opportunity Name is the header) and column P (Total Bookings (converted pulled in). I would like this to be pulled in to the summary sheet going down starting in row 57 in columns B and C (Opportunity Name in column B and Total Bookings (Converted) in column C. So when the name in $B$2 of the summary sheet is changed, it will trigger the macro to put the data in the summary sheet.
My programming experience is very limited but trying to learn! Please let me know if you have additional questions
