Hi There, Is there a way to lookup Customer in A1 in sheet 2 and return ALL result to sheet 3, once complete for that customer move on to customer in A2 and show all results from Sheet2 on sheet 3..... so on and so forth?
Hi There, Is there a way to lookup Customer in A1 in sheet 2 and return ALL result to sheet 3, once complete for that customer move on to customer in A2 and show all results from Sheet2 on sheet 3..... so on and so forth?
I'm sure there is, a long convoluted macro.
Or you could simply copy all the data to Sheet3 as a whole then sort Sheet3 by Column A to get the same result with no macro.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
then I would have to delete a whole lot of information. This is a report with thousands of rows and about 10 columns. I am just trying to extract the information I need for a new report.
I think you could probably adapt the code AB33 presents in Post #19 in this thread:
http://www.excelforum.com/excel-prog...r-sheet-2.html
Your question in post #1 does not imply any leaving of ANY information out, you indicated wanting to parse together ALL the rows for ALL the unique column A values and list them together on a new sheet. That is accomplished by simply SORTING the data a whole, then you can quickly delete the columns you don't really want.
You'll need to present a much clearer picture of what you want, so far your question does not exclude anything. So for now I think I'm right and perhaps if you try it, you'll discover it's only 60 seconds of work after all.
If not, post a workbook demonstrating how it's not as easy as what I've said. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks