Hi I was checking out your mail ,,,,i have a similar problem..could u help me out...i want the solution to be on the lines of what you have shown in your attachment data1.xlsm.
I am sending an attachment of the problem....could you please help me out??? On Tue, Jan 10, 2012 at 2:57 PM, Pranav N <nadab...@gmail.com> wrote: > > Its not clear what you need > any way i' m sending two files. > both are same. one in XLS format and other in 2007 format. > > based on values in column H it will search the data area,then create sheets > and updates data > > I don't know this is what you need! > > (my mails are not showing up in the group,that's why i'm mailing you > directly) > > > regards > -Sudheer > > > On Tue, Jan 10, 2012 at 8:35 AM, Monizri <moni...@gmail.com> wrote: >> >> Hello, i have this code, i apologize as it is messy. But i am trying >> to loop through two columns, i want the loop to read the column on the >> right and for eah item on the right i want the second loop to search >> through the "database" i have created and create a new tab for it. >> >> Here is the sheet, any help would be appreciated! >> >> Tx >> >> Matt >> >> here is the link >> http://www.box.com/s/uqbtzr1oe21folo0pmc2 >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com -- P J MOHAN -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
PROBLEM 30122011.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet