I'll try to explain better...
Sheet A has the basic info imported from a system report, column A is the company code, columns D thru N have the information for each company code, there are three to four rows of info for each company code, I need to filter that info to seperate tabs per company code (so one tab per company code with only that company's info on it), this should be like a macro so I only need to press a "botton" and the info from the first tab will filter to the following tabs by company code. SOMEONE PLEASE HELP SOON, I need to get this done by tomorrow!!!
Ok not sure how to state the question so I will explain my problem. I have basic info for multiple companies on one tab, each company as three to four rows of info for different coded purposes. I have one tab for each company, I need all the info for each company to filter to it's tab by clicking a "button" on the "data tab" (first tab with basic info). I know this can be done I just don't know the formula. I am running version 2010.
