Your description and sample is somewhat conflicting. You SAID: 1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for values. 2. If a value exists in column A, it ignores and go to next cell. 3. If a value doesn't exist in column A, then it copies Row 1 and paste it at the end (say at row 8 in attached file), then it fill-in the value in cell A8, and search for next value.
Yet in your sample, the value in Column A DOES exist, yet you copy line 1 to the indicated row. In the attached file, I did as you requested, not as your sample Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Amit Gandhi <silkyro...@gmail.com> To: excel-macros@googlegroups.com Sent: Fri, November 30, 2012 2:31:51 AM Subject: Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS Hi Experts I have created a list in "Name Manager" named "TTlist" for values shown in "LIST" sheet of attached file. I used to update this "TTlist" with some other macro. I have another sheet named "TT" in which 1st 5 rows are constant. I sued to fill-in data from 6th row on-wards. I need a macro which will help me doing following. 1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for values. 2. If a value exists in column A, it ignores and go to next cell. 3. If a value doesn't exist in column A, then it copies Row 1 and paste it at the end (say at row 8 in attached file), then it fill-in the value in cell A8, and search for next value. To summarise, i need solution as shown in sheet "SOLUTION_REQD". Pls help me here. Regards Amit On Wed, Nov 28, 2012 at 12:30 PM, Amit Gandhi <silkyro...@gmail.com> wrote: Hi Experts > > >I have created a list in "Name Manager" named "TTlist" for values shown in >"LIST" sheet of attached file. I used to update this "TTlist" with some other >macro. >I have another sheet named "TT" in which 1st 5 rows are constant. I sued to >fill-in data from 6th row on-wards. > > >I need a macro which will help me doing following. > > >1. Macro will check in sheet "TT" column A (A6 onwards) with "TTlist" for >values. >2. If a value exists in column A, it ignores and go to next cell. >3. If a value doesn't exist in column A, then it copies Row 1 and paste it at >the end (say at row 8 in attached file), then it fill-in the value in cell A8, >and search for next value. > > >To summarise, i need solution as shown in sheet "SOLUTION_REQD". > > >Pls help me here. > > >Regards > > >Amit > >-- >Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >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) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members >are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To post to this group, send email to excel-macros@googlegroups.com. >To unsubscribe from this group, send email to >excel-macros+unsubscr...@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
LIST CHECK & ADD ROWS.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
