Return Data on Search Criteria

[RicktheBlade]

I have created a workbook that requires data to be added to Sheet 1 and when save is clicked a Macro filters my input over to 11 different sheets depending on what was entered.

What I am puzzled about now is trying to return this data to yet another sheet in single row format.

Am thinking of a Macro that works upon clicking a search box then goes away and retreives your search one under another.



Am just looking for ideas at the moment as I am still puzzled at how i am going to tackle this.



Cheers
Rick

[JBeaucaire]

'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.

Sheets to One Sheet - Part 1

There's a sample file there, too, to make it easy to try it out.


Perhaps you can cull the techniques from there into your own project.

[RicktheBlade]

Awesome thanks heaps