Report to copy paste data based on matching criteria

**The_Snook** · 10-02-2013, 04:22 AM

Hi,

I've been asked to develop a report where people select certain criteria and then request the data matching that criteria to be returned. I've created an example of what i'm working with. I think the tricky part is going to be returning the correct price as it depends on the region selected (London or National).

To clarify i'm looking to build a report where people select criteria on the 'report' tab, upon request (prob a button) the report then looks for matching criteria on the 'data' tab and then returns that data to the relevant column on the 'report' tab. The actual data set i'll be working with will be quite large so I expect most searches to return a number of matches. The example i've provided should return two matches lines.

I hope this makes sense but if you have any queries give me a shout.

Thanks in advance,

Snook

**millz** · 10-02-2013, 04:47 AM

Try this. Open workbook, enable macros, and click on the button.

**The_Snook** · 10-02-2013, 05:27 AM

Massive thanks, it works an absolute treat!

My VBA skills aren't the strongest as i'm still learning but i'll have a bash at getting my head around it although I may have a further query(ies) around the logic/how it works if that's o.k.?

Regards,

Snook

**millz** · 10-02-2013, 07:19 AM

No problem, just ask if you have questions

**The_Snook** · 10-07-2013, 11:07 AM

Me again,

I've been trying to adapt the solution you provided to my actual data set but i'm clearly going wrong/misunderstanding somewhere because it isn't working.

I'd be grateful if you could copy and amend the code to the attached updated workbook which more accurately reflects the data structure i'm working with. I'll then hopefully understand where I was going wrong.

Thanks,

Snook

**millz** · 10-07-2013, 12:47 PM

I've amended to fit your actual data, this is also why you should have given a sample as close to your actual data as possible. I've also added comments hopefully to explain it more clearly to you.

Report to copy paste data based on matching criteria

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Report to copy paste data based on matching criteria

Re: Report to copy paste data based on matching criteria

Re: Report to copy paste data based on matching criteria

Re: Report to copy paste data based on matching criteria

Re: Report to copy paste data based on matching criteria

Re: Report to copy paste data based on matching criteria

Thread Information

Users Browsing this Thread

Similar Threads

Copy/Paste range of cells to another worksheet based on matching criteria

Copy and Paste data based on two criteria being met

[SOLVED] Copy, paste data based on a particular criteria

Copy Paste data with matching criteria from different sheet

Copy and paste data based on criteria

Bookmarks

Bookmarks

Posting Permissions