Copying specific data if criteria is met from workbook to workbook

**slyolfox** · 07-02-2011, 04:46 AM

Hi all,
I am fairly new to Excel and am struggling to grasp how macros work. I have two workbooks (VIP Pipeline) and (VIP Declines) saved in the same folder and I want to be able to copy certain data from VIP Pipeline to VIP Declines once a certain criteria is met. The VIP Pipeline has columns from A - AM and i want to copy cells C#,F#,X# from VIP Pipeline to VIP Declines if in Cell Y# the result is "Decline". Along with this I would also like the copied data to be in subsequent rows and the rows from where the data comes from (VIP Pipeline) to be deleted without upsetting any of the formulas. I know this is probably a big ask and i would be very grateful with any assistance

**royUK** · 07-02-2011, 05:04 AM

Why is this necessary, it's simpler to keep all the dta together, but have a column to mark declined, then use autofilter

**slyolfox** · 07-02-2011, 04:14 PM

The scenario i have posted is only the start, I work in a sales team of 13 people who all have their own pipeline spreadsheets, basically I need to put together the decline spreadsheet from all of the pipelines so that we can understand why we are losing sales and use it for reporting. Ultimately there will be an Acceptance Workbook also in the future.